How do you create headers and footers in a query?

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

Guest

I have to do a query and have a header and footer in it. I know how to get
the header and footers in regular reports but I don't know how to do it in
query. Please help.
 
There are no headers or footers in queries. If you can be more specific on
what you are trying to do, perhaps we can offer a workable solution.
 
Mnmgymnast13 said:
I have to do a query and have a header and footer in it. I know how to get
the header and footers in regular reports but I don't know how to do it in
query. Please help.
Click to expand...


Queries only have fields (which do have a Caption property
that is displayed at the top of a column), but that's it.
If you want to display things on the screen with a header
and/or footer, use a form based on the query.
 
Exactly what I thought. However, my teacher wants me to printout out my
query recordset to include my name in the header and the date in the footer.
I don't get how I can do it.
 
This teacher is teaching Access?????????
Drop the class :)

or maybe it is a trick question. You could do it be creating a report that
has your query as the recordset. It the page header, create a label with the
caption being your name. In the page footer, create a text box control with
the control source of =Date()
 
Thx for letting me know. I think my teacher may not have read what she wrote
on her instructions........oh well! I've emailed to her in the hopes that
she'll clarify.
Thx again.
 
Thx Marshall. You've verified my feelings. I now feel confident enough to
email my teacher for an answer.

I really appreciate it!
 
If you print preview a query and leave a top margin and a bottom margin you
will get the name of the query at the top and a page number at the bottom. I
use .35 for top and bottom margin. Could this be what your teacher wants?
 
Back
Top