Count of records

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

Guest

Hello

Is there anyway that I can have a textbox in the page header of a report showing the total number of records in the report

I am aware this figure would show up at the top of every page and that is fine. I tried Count(*) but page header didn't like it. Can anyone help

Mikey
 
Is there a reason you don't put this in the Report Header rather than the
Page Header?

--
Duane Hookom
MS Access MVP
Mikey said:
Hello.

Is there anyway that I can have a textbox in the page header of a report
Click to expand...
showing the total number of records in the report?
I am aware this figure would show up at the top of every page and that is
Click to expand...
fine. I tried Count(*) but page header didn't like it. Can anyone help?
 
Yup - because there are items I want to appear on every page, but I want the count to appear after these items..
Hence it has to be in the page header too

----- Duane Hookom wrote: ----

Is there a reason you don't put this in the Report Header rather than th
Page Header
 
Put it in the Report Header and name the text box "txtCount". Then add a
text box to the Page Header:
=txtCount

--
Duane Hookom
MS Access MVP
Mikey said:
Yup - because there are items I want to appear on every page, but I want
Click to expand...
the count to appear after these items...
 
Back
Top