Count Question

  • Thread starter Thread starter Randal
  • Start date Start date
R

Randal

Is there a way to use Count on an ID that is joined to another table in a
one-to-many relationship, but count only unique IDs. My count returns a
total of all the records in the query when I only want a count of the unique
IDs. I also need fields from the other tables in the query to sum up $$
amts, so I can't use unique values.
 

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

Similar Threads

Writing A Select Statement To Return a Count Of Unique Dates In aTable 2
Create a distinct Join 3
Unique Count 1
Count unique field1 combined with count field2, both grouped andungrouped 3
Counting records in a query 9
Return all records many to many 1
How do I use count in a query in Access 3
How to Populate Data from a table to another 0

Back
Top