How do you create headers and footers in a query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mnmgymnast13 - 20 Jul 2006 18:33 GMT

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.

Reply to this Message

Klatuu - 20 Jul 2006 18:41 GMT

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.

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

Reply to this Message

Mnmgymnast13 - 20 Jul 2006 19:09 GMT

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.

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

Reply to this Message

Klatuu - 20 Jul 2006 19:17 GMT

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

> 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.
[quoted text clipped - 6 lines]
> > > the header and footers in regular reports but I don't know how to do it in
> > > query. Please help.

Reply to this Message

Mnmgymnast13 - 20 Jul 2006 21:02 GMT

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.

> This teacher is teaching Access?????????
> Drop the class :)
[quoted text clipped - 14 lines]
> > > > the header and footers in regular reports but I don't know how to do it in
> > > > query. Please help.Thx

Reply to this Message

Parker - 20 Jul 2006 23:42 GMT

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?

> 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
[quoted text clipped - 10 lines]
>> > in
>> > query. Please help.

Reply to this Message

Marshall Barton - 20 Jul 2006 19:05 GMT

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

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Mnmgymnast13 - 20 Jul 2006 21:06 GMT

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

I really appreciate it!

> >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
[quoted text clipped - 4 lines]
> If you want to display things on the screen with a header
> and/or footer, use a form based on the query.

Reply to this Message