writing a query in Access?

Discussion in 'OT Technology' started by ZoRphic, Nov 4, 2003.

  1. ZoRphic

    ZoRphic BoBo

    Joined:
    Jul 11, 2001
    Messages:
    1,206
    Likes Received:
    0
    Location:
    NJ
    How would you go about writing a query in Microsoft Access?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    You definately need to try the tutorials - there's enought out there to get you familiar on how to set up the database and write a simple query. If you have a specific problem, that's something I'm willing to help you out on.
     
  3. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    rememeber ms access has its own modified version of sql... so if u look for sql help, it may be slightly different....
     
  4. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    Like 5Gen said, the sample programs included with Access are very helpful.
     
  5. also, use the visual query designer. it's a great learning tool.
     
  6. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    no. :nono: :slap: learn sql. its 1000x more stronger and quicker.
     
  7. SFLegend

    SFLegend .

    Joined:
    Sep 24, 2002
    Messages:
    263
    Likes Received:
    0
    Location:
    San Francisco
  8. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    I disagree here. Visual tools are a great stepping stone. A lot of people who can't code find that learning something visually is much easier. And lets face it, 99% of all queries are coded exactly the same regardless of whether a designer writes the code, or you do.
     
  9. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    honestly i find access code builder is bloated, adding extra "features" that isnt required. and its mass brackets are ugly aswell.

    something like myphpadmin fucking rocks!

    but then my 1st sql experiece was with paradoxx.... 2nd major experiece was with oracle 9i.
     
  10. Black Light

    Black Light Guest

    What query do u need to write? What version of Access r u using?
     

Share This Page