PDA

View Full Version : Acces query help

Anonymous
03-04-2002, 03:44 PM
does SQL work better than using the "!" button to run a query?

thanks

GG
General Kenobi (ret.)
03-04-2002, 03:50 PM
Huh? All queries have SQL underlying them.
Anonymous
03-04-2002, 03:52 PM
yes, but which is most efficient for on doing actuarial analysis type work where speed means more efficiency?

thanks for your response,
Ammie
03-04-2002, 05:18 PM
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.