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

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

Query to find duplicate appointments 1
import data from excel command button 2
import data into SQL Server from Excel 1
import data into a SQL Server 200 table from a command button 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Select row by ID to nearest date, future (or past if no future dat 4
Counting number of items excluding duplicates. 1
records beyond some limit 2

Top