Hi goodguy. Yes, combining all the locations at a query level would be an option.

What I am trying to express here is that the location data for each client...

Thanks for the reply Derrick. I appreciate your time.

The locations are entered into a PDA device, in fields called LocationA, B, C and Room. As I described before, the content...