 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Viewing N of TotalN Records
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  SignatureDuane Hookom MS Access MVP -- > Hello group - > Using Access 2000 REPORTS [quoted text clipped - 10 lines] > > How can I show this data on each printed page? Duane, Thanks, it worked! > Try place a control in your report header section: > Name: txtCountAll [quoted text clipped - 17 lines] > > > > How can I show this data on each printed page? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.