If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count records in a report
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! -- WendyF |
#2
|
|||
|
|||
Count records in a report
Wendy F wrote:
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. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
Count records in a report
Place your text box in the report header or footer section rather than the
page footer. -- Duane Hookom Microsoft Access MVP "Wendy F" wrote: 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! -- WendyF |
#4
|
|||
|
|||
Count records in a report
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. -- WendyF "Marshall Barton" wrote: Wendy F wrote: 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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|