Query to find and COMBINE rows based on 2 fields

[admessing]

Hello all-



I am building a photo archive DB for a project at work. Now, I just need to build a query that will search for records that have identical entries in 2 fields, then return the combined records as a single row.

The fields that need to be searched are (they are GPS coordinates):
Easting_UTM
Northing_UTM

The fields that need to be returned for the final product in a SINGLE row are:
Watershed
Stand_Number
Easting_UTM
Northing_UTM
Photo_Year (1)
IMG_North (1)
IMG_East (1)
IMG_South (1)
IMG_West (1)
Photo_Year (2)
IMG_North (2)
IMG_East (2)
IMG_South (2)
IMG_West (2)
....etc

How in the world of Access 2007 can I do this?

[admessing]

The resulting product of the query also needs to return any records that do not have a duplicate location. This DB is going to be used in conjunction with mapping software, so all valid coordinates need to be included, but the software will only recognize one set of images per coordinate location. Hence the need to combine the images under a single row for each location, noting the year(s) that the images were acquired.

[admessing]

I managed to solve this question through trial and error. Thanks for taking a look even though I did not get any replies. Will keep this forum linked on my browser for future use.