They allow you to perform a wide variety of very powerful analysis and actions.
For information about entering new data in a database, see the article Add one or more records to a database.
Luke Chung is the president and founder of FMS, Inc., a database consulting firm and the world's leading developer of Microsoft Access add-in products.
He is the designer and co-author of several Access add-ins including Total Access Analyzer, Total Visual Code Tools, Total Access Detective, Total Access Emailer, Total Visual Source Book, and Total Access Statistics. This information may not be republished, reprinted or retransmitted in any form without the express written permission of FMS Inc.
Thats a lot of work and a pain to maintain or understand. By using temporary tables, you can eliminate a lot of unnecessary code. To create a Make-Table query, open the query (qry Customer Sales) in design mode, and choose Make-Table Query from the Query menu.
Make-Table queries are just like Select queries except their results are put into a new table rather than a datasheet view. A dialog lets you specify the name of the output table: Make Table Query puts its results in table: tbl Temp Customer Sales Once you create the temporary table, using it rather than the summary query allows the two previous examples to work: An alternative to Make-Table queries is an Append query.
The database can be linked to a shared database containing the data, but your application must be in a separate database.