Counting records queries

  • Thread starter Thread starter _Adrian
  • Start date Start date
A

_Adrian

Hey all.. I've looked at the online help, but without finding an answer..
I've got a query returning the records I need, but I also need this same
query to total up the number of records it retrieved so that I can add that
value to the generated report.. suggestions?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The same query can't return it's own recordcount as a separate row in
the query.

On the report footer you can put a TextBox control & set it's
ControlSource to this:

=Count(*)

It will print the count of all the records the report printed.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQcMxCoechKqOuFEgEQJETgCeIMzXaiuD55kB5rddnxKfCM7oflIAnjrl
H1uRISPH2+/czJmIQshB5mjz
=uHQN
-----END PGP SIGNATURE-----
 
Back
Top