Row Counting

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

Guest

How would I go about displaying a count of rows that make up my pass
criteria. For instance I create a query list of all persons that have in 'y'
in the paid field.
 
Bill said:
How would I go about displaying a count of rows that make up my pass
criteria. For instance I create a query list of all persons that have in 'y'
in the paid field.
Click to expand...


Where do you want to display the count? If you open the
query in sheet view, the nav buttons will automatically
display then number of records.

If you are using the query as the recordsource for a form or
report, then use a text box (in the form/report
header/footer section) with the control source expression:
=Count(*)
 
Back
Top