Count distinct record

[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

 

[Marshall Barton]

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

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.