I have a (probably simple) question about access reporting.
I have a report that uses a query, resulting in some rows having the same value for one field (Job ID).
I have a text box in the report footer which has the Control source set to =Count([Job ID])
This works of course, but gives the total number of records, where I want the total of distinct records.
Is there any syntax that I can insert into that report text box to give me the Distinct value. I tried Dcount([Job ID]) but it didn’t like that!!