I've been stuggling with this for days and I can't seem to find a solution online, however I've found similar references but can't get them to work. I tired searching this forum and can't provide the proper key words to find a sample. I would greatly appreciate any assistance. I'm using Access 2000 and working off a query: I have a query called "Provider And Address Detail Combine Q". This query qroups all doctors by their PPOOK_PROV_ID and Full Address and I'm looking for a continuous count of the address grouped by PPOOK_PROV_ID. The object is to provide each Address (FullAddress) with a location number for each provider. Below is the results I like to obtain.
PPOOK_PROV_ID, FullAddress, Count (location#)
123456, 123 Fourth St, 1
123456, 9 Nineth St 2,
123456, 1 Hunderd Ave, 3
123456, 19 Seventy Blvd., 4
987654, 98 Hunters Lane, 1
987654, 1 Four the Road, 2
Thank you in advance for taking the time to help me.