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.
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.