[AccessD] unique patients

pedro at plex.nl pedro at plex.nl
Thu Nov 3 09:43:58 CDT 2011


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




More information about the AccessD mailing list