count problem

H

Homie

i have a table with "client_id", "ethnicity" and "date". the client_id field
can have duplicates as the table only holds temporary information based over
a period of time. if i count that field i get a result totalling the number
of records. what i want to do is count the number of individual client_id's.
i.e. if client 147 is in the table 8 times it will only be counted once.
 
H

Homie

ok i went round and round with this. i know it must be something people need
often and i cant believe how simple it was when i finally got round to doing
exactly what u said... thank you very much :)
 
T

tina

you're welcome :)


Homie said:
ok i went round and round with this. i know it must be something people need
often and i cant believe how simple it was when i finally got round to doing
exactly what u said... thank you very much :)
Click to expand...
 
Top