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.
closed as off-topic by Paul White♦, RolandoMySQLDBA, Colin 't Hart, Max Vernon, ypercubeᵀᴹ Mar 23 '15 at 9:25
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, RolandoMySQLDBA, Colin 't Hart, Max Vernon, ypercubeᵀᴹ
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:
There's not really a good online "build my query for me" resource. It's rather the reason most of us goto school and study mathy concepts and learn how to do these things with lots of study and peer review. I realize this doesn't help you, but it helps to understand the resounding "NO" you're going to get.
Now you do realized Microsoft has a visual query editor right? Kind of click and drag sort of builder. I figure you do.
I suggest asking a specific question about a specific query and specifying that you don't understand the problem for more help in the future.