I am writing a report based on a query of 2 related tables. One table is of mailings sent out, with a primary key called Hard ID. The other table is of places the mailings were sent to with a primary key called ID. As you can imagine, one mailing may go to several places, so when the query is run, the same Hard ID will be listed for each recipient of a particular mailing.
In my report, I am able to count in the report header the total items sent out by just entering =Count([QueryName]![ID]), but how can I count the unique Hard IDs? There may be 10 mailings, but 100 total items sent (and records in the query) because each mailing goes to several recipients. The count of [ID] returns the 100, but how can I get the 10 (unique [Hard ID])s?
I'm sure I am missing something very minor, But thanks in advance!
In my report, I am able to count in the report header the total items sent out by just entering =Count([QueryName]![ID]), but how can I count the unique Hard IDs? There may be 10 mailings, but 100 total items sent (and records in the query) because each mailing goes to several recipients. The count of [ID] returns the 100, but how can I get the 10 (unique [Hard ID])s?
I'm sure I am missing something very minor, But thanks in advance!