[AccessD] unique patients

Hi Pedro

First use a query with DISTINCT to remove the double entries like A-ee-101.
Then use this query as source in another query whery you group by Uitv and Sub and count Patient.

/gustav


>>> pedro at plex.nl 03-11-2011 09:43 >>>
Dear Group,

how can i query the unique patients, from "Uitv" and "Sub". 

Data		

Uitv	Sub	Patient
A	ee	101
A	ee	101
A	ee	102
A	ff	201
A	gg	301
B	ee	201
B	ee	301
B	hh	501



Result		
		
Uitv	Sub	Unique Patient
A	ee        2
A	ff	  1
A	gg	  1
B	ee	  2
B	hh	  1


Thanks

Pedro Janssen