How do I count without counting duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the count function for a group of records in Access 2000.
For example:

101
101
102
102
103
104
104
I need to count without duplicates. Is this possible? Thanks in advance
for any assistance.
 
Use two queries - first one just group. Second one like this --
SELECT Query1.xx, Count(Query1.xx) AS CountOfxx
FROM Query1
GROUP BY Query1.xx;
 
How do I get this information into my report? Can you use multiple filed
lists in reports? Do they have to have a relationship established? I am
self taught on access and apologize if these seem to be silly questions. I
have not found any user book for access 2000 that is helpful in anyway. If
you have any suggestions I would greatly appreciate it.
 
Back
Top