Display total number of records in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to get a simple record count in the footer of my report. I have tried
= count but no success. I run Windows XP but I notice my Access program
reads "Access 2000 file format". Can anyone help?
 
You stated "in the footer of my report" but I think your text box is in the
"Page" footer. The expression will work in every section of your report
except the Page Header and Page Footer.

--
Duane Hookom
MS Access MVP

Eloy said:
I have tried =count(*), =count([field]), etc and they all return errors

Duane Hookom said:
Try a control source of:
=Count(*)
Click to expand...
Click to expand...
 
You are absolutely right!!! Thanks for your help! Onto creating reports!!!

Duane Hookom said:
You stated "in the footer of my report" but I think your text box is in the
"Page" footer. The expression will work in every section of your report
except the Page Header and Page Footer.

--
Duane Hookom
MS Access MVP

Eloy said:
I have tried =count(*), =count([field]), etc and they all return errors

Duane Hookom said:
Try a control source of:
=Count(*)

--
Duane Hookom
MS Access MVP

I need to get a simple record count in the footer of my report. I have
tried
= count but no success. I run Windows XP but I notice my Access
program
reads "Access 2000 file format". Can anyone help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top