Viewing N of TotalN Records

E

E

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?
 
D

Duane Hookom

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
 
E

E

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...
 
Top