Combining Multiple Records

[jfredel via AccessMonster.com]

Thanks in advance for any assistance.

I have a data file that contains unique members with a unique IDs. Some
members may have various locations or various levels. Lets say the maximum
locations and maximum levels are 3 each.

Currently each record only reflects 1 location or 1 level. I need to end up
with 1 record that shows all locations and all levels.

Output should look like:

ID MemLame Memfname Location1 Location2 Location3 level1 Level2 Level3

Thanks again
Jeff

 

[Jeff Boyce]

Jeff

You haven't described your underlying data structure. Since queries depend
on the data they work with, it would only be guessing to offer suggestions.
Can you explain a bit more what data you are querying?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/