Count records in a report

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

Guest

I hope someone out there can help. I have a report which was built through
an existing query. It does the following. I have a meetings database set up
and I set up a query to show only those records relating to a specific
meeting using a perameter query and this works fine. What I would like to do
is put in the footer of the report page a count (so it will count the number
of records/people attending the meeting) I have tried using the =Count(*) in
a text box in the footer but it just comes back with an #error can anyone
help with this I would appreciate it. thanks!
 
Wendy said:
I hope someone out there can help. I have a report which was built through
an existing query. It does the following. I have a meetings database set up
and I set up a query to show only those records relating to a specific
meeting using a perameter query and this works fine. What I would like to do
is put in the footer of the report page a count (so it will count the number
of records/people attending the meeting) I have tried using the =Count(*) in
a text box in the footer but it just comes back with an #error can anyone
help with this I would appreciate it. thanks!
Click to expand...


The aggregate functions do not work in the page
header/footer sections because a page is not a data related
grouping.

Put the Count(*) text box in the report header section and
then refer to that in the page footer.
 
Thanks Marshall & Duane

it works fine now. I can't believe I did not think to put it in the report
footer rather than the page footer. So many thanks to both of you.
 
Back
Top