Simple Summary

[simon4amiee]

LOCALID - POSTCODE - GPCODE
PTO1395164 - DN34 1AB - G9999981
PTO1395164 - DN34 1AB - G9999981
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - DN34 1AB - G8909058
PTO1395164 - TZ14 2AX - G8909058
PTO1395164 - TZ14 2AX - G8909058



Hi guys, this is a simple query I know by just can’t recall how to do this.

The sample data above shows 1 customer with several episodes (different attend dates – not important here), during the course of these attendances they moved home and moved GP practice.

Is there a simple way in Access to show a summary of this eh HEY1395164 = 2 postcodes, 2 GP’s

 

[Ranman256]

In the query design, bring down all 3 fields.
click on the grey space between the table, NOT the table, the gray space (then view query property)
in the property sheet, set UNIQUE VALUES = YES.
run query.