Simple Summary

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

Simple Summary