Count records in a report

[Wendy F]

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!

 

[Marshall Barton]

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!

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.

 

[Duane Hookom]

Place your text box in the report header or footer section rather than the
page footer.

 

[Wendy F]

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.