Combining Multiple Records

  • Thread starter Thread starter jfredel via AccessMonster.com
  • Start date Start date
J

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

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicating data according to Dates 2
Union query - sort of 4
Maximum Sales 2
MS TreeView - child checkbox items still checked after parent hasbeen unchecked 1
Counting multiple memberships 1
For Each Field in a Table... 4
code to match and sort 5
Need an input box when user selects a value in a drop down box 4

Back
Top