Need to create a counter, need help

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

Guest

How can create a counter, I have genterated a report from a query. That query
has to meet a couple of critiria's, one being a course number and course
date, I need to know how many students are on this report.
Thanks
 
If all you are interested is in totals use the totals function in queries
looks like a big Z however I doubt this is what you want. I think you want to
make a textbox in your report/group footer that has the following for the
control source '=Count([last name])' last name being a field in your report
detail section.

HTH
Martin
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you include a unique identifier, like StudentID, you can create a
Text Box in the report's Footer, or Header, section w/ a ControlSource
property of:

=Count(StudentID)

This will return the number of StudentIDs on the report.

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

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

iQA/AwUBQYEq54echKqOuFEgEQJUygCfTspb1ATFsxmcMxI3ICIqid+nUlIAoO9O
3BL1Ry46Xbm5gSPtGzBQWyWs
=vu5P
-----END PGP SIGNATURE-----
 
Back
Top