Datasheet

Figure 1-29 Here are your query results.
Exporting query results
Now that you have learned the basics of creating queries, you need to be able
to export these results back to Excel or another format. The simplest way to do
this in Access is to right-click the query after it has been saved. Select Export
and choose the appropriate file type. The query will take a snapshot of the data
at that moment in time and save the results in the requested format.
Tricks of the Trade: Outputting to Excel without Saving Anywhere
Open up the TransactionMaster table and highlight the first 10 rows, as shown
in Figure 1-30.
Figure 1-30 Highlight the data you want to output to Excel.
continues
Access Basics 37
05_59978X ch01.qxp 12/1/05 7:46 PM Page 37