Query Header and Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top