Printing current date

[smiller]

When I print queries (and maybe forms) I would like to have the date printed on the sheet so I know when I printed it out. How should I do this??

Thanks

 

[Rich]

Queries and Forms are not designed for printing, use Reports instead

 

[mhartman]

Hello:

In your report footer, place a two text boxes with the following as the ControlSource:

=Now()

="Page " & [Page] & " of " & [Pages]

The first entry would go in the Left text box
The second entry would go in the right text box

Regards
Mark

 

[smiller]

thanks so much

 

[mhartman]

Hello:

Your welcome and good luck with this.

Regards

Mark