report footer

D

Darryl

Greetings,
I am running Access 2000.

I have a report that I created with data source that is a query.

What I need to do is print the output from a second query in the
report footer.

like:
Report header
Page header
detail
Report footer
record 1
record 2
record 3.

Any ideas ?

-Darryl

BTW, sub report doesn't seem to do the trick as the page header shows and I
need that supressed.
 
R

Rob Parker

If you can't use a sub-report, then (since a report can only have a single
recordsource) you have two choices:

1. Combine both your queries into a single query which you use as the
recordsource for your report, and put the appropriate data fields into the
detail and report footer sections.

2. Use dlookup statements in the report footer to get the data from the
second query (this is only likely to be a usable option if the second query
returns a limited dataset).

HTH,

Rob
 

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

Top