Query from multiples into one record?

[wmrainer]

We have a query that pulls information from four tables. What we need to do is do a query or something else to pull the data from the existing query into a table/excel file. The problem we are having is that we want just one record for each person with all of their class selections in one field. Is this doable? Thanks for all your help!:banghead:

 

[JHB]

It's not something I would recommend as it can cause you problems later, but for what reason you may have, look at the thread
http://www.access-programmers.co.uk/...d.php?t=248376 post #6, it is exactly the same you are asking for. The Names = yours "class selections" and the Address = yours "person".

 

[wmrainer]

I think this will definitely work....we are using Access 2003. Could you save the DB in mdb format for me? Thanks so much for your help!

 

[JHB]

I would post it in MS-Access 2003 MDB-format this morning, but something is wrong with this site, it is running slow and the attached opportunity isn't available. I'll post it later when everything is running perfect.

 

[JHB]

Today the site seems to run better, so here is the database in MS-Access 2003 MDB-format.