Count Function

  • Thread starter Thread starter ELo
  • Start date Start date
E

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?
 
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
 
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.
 
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 said:
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 said:
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?
Click to expand...
Click to expand...
 
I have placed this within the report footer but it is not visible when i
preview this?

John Spencer said:
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?
Click to expand...
.
Click to expand...
 
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 said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top