Office 2007 Bible

Printing a Query’s Recordset

After you create your query, you can easily print all the records in the recordset. Although you can’t specify a type of report, you can print a simple matrix-type report (rows and columns) of the recordset created by your query.

You do have some flexibility when printing a recordset. If you know that the datasheet is set up just as you want, you can specify some options as you follow these steps:

1.	Use the datasheet you just created for both sellers and buyers that have been customers since 01/01/2007.
2.	If you are not in the Datasheet view, switch to the Query Datasheet mode by clicking the Datasheet button on the Design tab of the Ribbon.
3.	Choose Office Button Print.
4.	Specify the print options that you want in the Print dialog box and click OK.

The printout reflects all layout options in effect when you print the dataset. Hidden columns do not print, and gridlines print only if the Gridlines option is on. The printout reflects the specified row height and column width.