Count of records

[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

 

[Duane Hookom]

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

--
Duane Hookom
MS Access MVP

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?

 

[Guest]

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

 

[Duane Hookom]

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

Yup - because there are items I want to appear on every page, but I want

the count to appear after these items...