report footer

  • Thread starter Thread starter Darryl
  • Start date Start date
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.
 
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
 
Back
Top