Acces query help

does SQL work better than using the "!" button to run a query?

thanks

GG

[General Kenobi (ret.)]

Huh? All queries have SQL underlying them.

yes, but which is most efficient for on doing actuarial analysis type work where speed means more efficiency?

thanks for your response,

ggallen
Anything you build using the table format will automatically be converted to SQL. I haven't noticed any performance improvement by clicking on SQL mode and running your query from there.

Generally I use SQL mode in the following circumstances:
1. When the expression is too complex to be represented by the table schematic.
2. When I want to run the query within VB code

Hope that helps.