Counting records (2003)

Topic

New Reply

O have a database that summaries a lot data. It is grouped by Company code (we have 12), type of review (2) and then it adds the reimbursements amounts. Within the report it sorts by audit number. I have 805 records. There are only 32 audits. I need to have a count of unique audit numbers at the bottom where I display all my grand total information. Everything I try (which is limited) gives me 805 audits. How can I +1 when there is a change in audit #??? Or is there another way?

Thanks,
Deborah

Reply | Quote

Replies

I’d create a query qryAuditNumbers that returns the unique audit numbers, e.g.

SELECT DISTINCT [audit_number]
FROM [some_table]

Place a text box on your report with control source

=DCount(“*”, “qryAuditNumbers”)

Reply | Quote

Hans,

I was on the right page but I could not get it to work. I have the field name in the Dcount instead of the query. Thanks for your help. It worked and I feel good that I at least was on the righ path!

Reply | Quote