Asger Blond
ab-mi at post3.tele.dk
Thu Nov 3 17:25:05 CDT 2011
Pedro, I don't understand your example with the data provided. Could you please tell if you made some typos - especially: Why is the data "A ee 102" not listed or counted in the result, and why is the data "B ee 201" and "B ee 301" listed as a count of 2 in the result? IOW: What's defining a unique entity for the counting in your example: Uitv + Sub or Uitv + Sub + Patient? Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af pedro at plex.nl Sendt: 3. november 2011 09:44 Til: accessd at databaseadvisors.com Emne: [AccessD] unique patients 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com