Query Header and Footer

M

Mary Ann

I want to change the default information which prints at the top/bottom of a
query – currently I have the query name and date in the “header†and page
number in the “footerâ€.

I see from Page Setup that I can uncheck Print Headings to remove all of
them, but I want to be more selective and add some of my own content.

How do I do this? There does not seem to be a “normal†header and footer
option.

I am using Access 2003, database 2000
 
J

John Spencer

Short answer: You cannot. Queries are for selecting data and in most cases
should be used as the source for a report or a form.

If you want to have custom headers and footers, you must use a report that
is based on your query.
 
Top