How do I count distinct rows in an Access report control source

G

Guest

I have a record source with duplicate ID #'s and I want to count the number
of distinct ID's in a group footer. I basically want to create a text box
with the count of distinct ID's.
 
L

Larry Linson

I have a record source with duplicate
ID #'s and I want to count the number
of distinct ID's in a group footer. I
basically want to create a text box
with the count of distinct ID's.

Use a DCount function as the ControlSource, based on a Query where you
Select the Distinct IDs. In the Query Builder, right-click the upper part,
choose Properties, and Unique Values or Unique Records. When the Query
returns the values you desire, save it and use it as the source for the
DCount.

Larry Linson
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top