Row Counting

[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.

 

[Marshall Barton]

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.

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(*)