Viewing N of TotalN Records

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

Guest

Hello group -
Using Access 2000 REPORTS

I want to show:
"X records of TotalX" on each page of a report (x is incremental, TotalX is
all records)

I got the X part working, I cannot get the TotalX.

Instead, I am getting "#Error" for TotalX.
The ControlSource is set to "=Count(*)"

How can I show this data on each printed page?
 
Try place a control in your report header section:
Name: txtCountAll
Control Source: =Count(*)
Visible: No
Then use a control source in your page footer like:
Control Source: =txtCountAll
 
Duane, Thanks, it worked!

Duane Hookom said:
Try place a control in your report header section:
Name: txtCountAll
Control Source: =Count(*)
Visible: No
Then use a control source in your page footer like:
Control Source: =txtCountAll
Click to expand...
 
Back
Top