|
| 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
December 17th, 2009, 07:54 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Count Function
I am creating a report for pupils, grouped by school then collection time.
I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout? 
|
|
#2
December 17th, 2009, 08:16 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Count Function
You can do this in the REPORT footer.
You canNOT do this in the PAGE footer. Does that help? John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County ELo wrote: I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout?
|
|
#3
December 17th, 2009, 08:36 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Count Function
You stated only "the footer" without specifying if this was a group, page, or
report footer. If it is a PAGE footer, the expression won't work. You should be able to use the same expression in the Report Footer as long as the name of the control is not the name of a field. -- Duane Hookom Microsoft Access MVP "ELo" wrote: I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout?
|
|
#4
December 17th, 2009, 08:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Count Function
I placed this within the Report Footer and it is not appearing within the
report in layout view? I used the count of individual groups in the collection time footer and the same formula in the Report Footer in the section below the Page Footer, i dont undestand what exactly you mean by not having the Control the same as the name of field, sorry? "Duane Hookom" wrote: You stated only "the footer" without specifying if this was a group, page, or report footer. If it is a PAGE footer, the expression won't work. You should be able to use the same expression in the Report Footer as long as the name of the control is not the name of a field. -- Duane Hookom Microsoft Access MVP "ELo" wrote: I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout?
|
|
#5
December 17th, 2009, 09:00 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Count Function
I have placed this within the report footer but it is not visible when i
preview this? "John Spencer" wrote: You can do this in the REPORT footer. You canNOT do this in the PAGE footer. Does that help? John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County ELo wrote: I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout? .
|
|
#6
December 18th, 2009, 03:09 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Count Function
Apparently you moved it from the Page to the Report footer and now you can't
see it. Does the count display in the report footer in the preview and print of the report? -- Duane Hookom Microsoft Access MVP "ELo" wrote: I placed this within the Report Footer and it is not appearing within the report in layout view? I used the count of individual groups in the collection time footer and the same formula in the Report Footer in the section below the Page Footer, i dont undestand what exactly you mean by not having the Control the same as the name of field, sorry? "Duane Hookom" wrote: You stated only "the footer" without specifying if this was a group, page, or report footer. If it is a PAGE footer, the expression won't work. You should be able to use the same expression in the Report Footer as long as the name of the control is not the name of a field. -- Duane Hookom Microsoft Access MVP "ELo" wrote: I am creating a report for pupils, grouped by school then collection time. I have managed to count the number of pupils being collected using the formula =count([Child Last Name]) However i cannot seem to get an overall total for each collection time in the footer, using the same formula results in 'Error' occurring in the layout?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
