Is there any way to write queries in access like you could in SQL? Eg. JOIN, GROUP, SELECT etc. It's just I have linked a MySQL database to it and I need to run some queries so I can output the data how I want it. It would probably require some VB work though? Any nice tutorials on the matter would be great

Cheers by dears,
~Jordan

If you are working in access, start a query in design view, choose your tables, then right click on the query box and select SQL view.


This should allow you to enter your query manually.


If I understood you that is what you were looking for.

Josh

Cheers mate, I will try it next time I get access to the server