|
| 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
July 16th, 2007, 08:58 PM
posted to microsoft.public.access.reports
|
|||
|
|||
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
July 16th, 2007, 10:22 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
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
July 16th, 2007, 10:32 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
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
July 17th, 2007, 08:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
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 | |
|
|
Linear Mode
