Doing Queries in Access is Aggravating

[Guest]

guys, i'm trying to learn SQL, but it is hard writing my own queries because
access uses a lot of symbols that i don't understand. What should i do? Is
there a way to write plain SQL without the brackets?

I can't test any of my queries out because i don't know how to do the crap
in Access.

Thanks guys!

 

[Guest]

try using the querry builder wizard. It works great for standard application
use and writes it into SQL that can be viewed in the design view process by
right clicking on the query while in design view and selecting SQL view.

May help....

Hansford Cornett

 

[Van T. Dinh]

Switch to SQL View in you are more familiar with writing SQL.

OTOH, note that different flavour of SQLs have different syntaxes. You will
need to check the JET SQL Reference section of Access Help for JET SQL
syntax.

You may want to use the ANSI-92 option rather than the default JET if you
are more familiar with ANSI-92 SQL.