How do you create headers and footers in a query?

M

Mnmgymnast13

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

Klatuu

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

Marshall Barton

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

Mnmgymnast13

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

Klatuu

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()
 
M

Mnmgymnast13

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

Mnmgymnast13

Thx Marshall. You've verified my feelings. I now feel confident enough to
email my teacher for an answer.

I really appreciate it!
 
P

Parker

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?
 
Top