I am looking for an online resource for writing Access SQL statements. I write queries using SQL because the UI puts limitations on what can be queried. I have been using w3schools for reference, however MS-Access sometimes has slightly different syntax, so when I run the query I get an error. Then I end up wasting time trying to figure out what I did wrong only to find out that Access does it differently.
Here is Microsoft's page about Access SQL syntax:
and here is a tutorial about Access SQL syntax for Access 2000. A bit dated, but the concept is still there:Tweet