Thu 21 May 2009, 15:59Delegate Stuart said...
Stuart has attended:
Access Intermediate course
MS Access
Is it good practice to create "chains" of queries (which use data from other queries, which use data from other queries etc.) to produce a final table of results or is it better to use a series of action queries which are run in a particular order to create a table and manipulate the data in it?
Fri 22 May 2009, 15:18Trainer Carlos said...
RE: MS Access
Hi Stuart
The problem of Action Queries is that the action is permanent. So a Make Table query creates a physical table in your database.
Chains of queries are more useful because, while slow, do not change the look of the database.
You should never create a table as a one off, but create it if you are going to make use of it regularly.
Hope this helps
Carlos
