Q: Record count in page header

M

MarkD

Hi,

I'm using access 2000 and want to be able to get the
recordcount of a report put on the page header. Using
reports("reportname").count doesn't give the right number.

The only way I know how to do this is to open the query as
a dao.recordset, count the # of records, then save that
information. But since the query is based on form fields,
I don't want to have to go through all the coding.

Any ideas?
Thanks,
-Mark
 
D

Duane Hookom

You can add a text box to your Report Header section
Name: txtCountAll
Control Source: =Count(*)
Add a text box to your Page Header
Control Source: =txtCountAll
 
M

MarkD

-----Original Message-----
You can add a text box to your Report Header section
Name: txtCountAll
Control Source: =Count(*)
Add a text box to your Page Header
Control Source: =txtCountAll

--
Duane Hookom
MS Access MVP
--




.
Click to expand...
 
Top