counting only shown records in a rpt (1 Viewer)

[kalicinski]

i have a report that opens after selecting certain criteria in a previous form. the report itself is grouped by PERIOD. i can get textboxes in the period footer to sum/count records for each period. but the query can also select only certain records that match a GROUP within that PERIOD. i cannot get the counters to only count the records that come out of the query.
any suggestions?

tks, AK

 

[jstutz]

Try using the Dcount function on your query. Like:

Dcount("FieldName","QueryName")

Dcount counts the number of instances of the field specified by FieldName. It's best to use your Primary Key in FieldName so you know it will always have data otherwise Dcount will not return an accurate count of the records in your query.

js