I have a table in access of 42,000 plus rows which contains
column1 = City Column2 = State Column3 = zip
Now it has multiple rows for cities with multiple zips. SO you could have have four rows as such: (Note Raleigh is Column1, NC is Column2, and 29706 is Column3)
Raleigh NC 29706
Raleigh NC 29707
Raleigh NC 29708
Raleigh NC 29709
I want to search the table and return the City State one time as such "Raleigh NC" with all the zips that are related to it in a single column in a query (IE: result being like such)
Raleigh NC 29706 29707 29708 29709
I have been trying to accomplish this for a week now and have found tons of concats and such but none seem to remove the duplicate cities and list the zips in the same cell with the city state as one column record.
Any help would be greatly appreciatted.