Count Function

[ELo]

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?

 

[John Spencer]

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

 

[Duane Hookom]

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.

 

[ELo]

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?

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

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?

 

[ELo]

I have placed this within the report footer but it is not visible when i
preview this?

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

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?

.

 

[Duane Hookom]

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

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?

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

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?