View Full Version : Acces query help
03-04-2002, 03:44 PM
does SQL work better than using the "!" button to run a query?
General Kenobi (ret.)
03-04-2002, 03:50 PM
Huh? All queries have SQL underlying them.
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,
03-04-2002, 05:18 PM
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.
vBulletin® v3.7.6, Copyright ©2000-2013, Jelsoft Enterprises Ltd.