Counting Unique Records in a Report

[Moxioron]

Hello all.

I have a report that I put together with totals at the bottom.

This is a detail report that reflects [Card Number] and [Amount] so at the bottom i have a total transaction text box that works fine.

I would also like to capture the total [Card Number]. However, since the same card number can show up several times, I don't get the actual count.

Can you count just the unique records in a report from a text box?

Thanks for your help.

 

[boblarson]

Just use a separate query which uses the query that the report is based on like:

Select Distinct IDFieldName From QueryNameHere

And then you can either use a DCount on the report or you can use a subreport. I would use a DCount:

=DCount("*", "YourSecondQueryNamehere")

 

[Moxioron]

Thank you sir. Worked like a charm.