Count distinct record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I Have the following record in a report

P1201D
P1201D
P1200N
P1201N

I want to get the distinct count of these record (without duplicate) so the answer of my exemple is distinct count = 3

Thanks
FRED
 
FRED said:
I Have the following record in a report

P1201D
P1201D
P1200N
P1201N

I want to get the distinct count of these record (without duplicate) so the answer of my exemple is distinct count = 3
Click to expand...


I think your best bet is to use a subreport based on a
totals query that calculates the count. It could be
something like:

SELECT Count(*)
FROM table
GROUP BY thefield

Another way is to group the report on the field and use a
counter text box in the group header or footer.
 
Back
Top