I have a query with 5-fields:
- ZipCode
- PostOffices
- County
- State
- Map (Map#)
* Now many ZipCodes/PostOffices are on more than 1-Map#. So, let’s say ZipCode/PostOffice ‘19001 Abington’ is on Map# ‘3258’ ‘3259’ ‘3370’ ‘3371’ & ‘3372.’ In my ZipCode Table/Query I’ll have 4-Records pertaining to ZipCode/PostOffice ‘19001 Abington.’
I want to have another Query which just list ‘19001 Abington’ once as well as the other ZipCodesPostOfficess multi listings. Originally I had a YesNo field & checked off every first ZipCodePostOffice entry. Last night I thought that I could eliminate my YesNo field by creating another query with the fields; ‘ZipCode’, PostOffice’, ‘Co’, & ‘St.’ then, under ‘PostOffice’ in the Total Grid choose “first. This moring when I opened the query it didn’t work. Next I tried, “Min” & that didn’t work. If I have a list of duplicate data in fields how can I only query the first Record? Shouldn’t “First” or “Min” work?