Attempting to combine records in Query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a table with only two fields per record:

Customer ID | Response

It is possible for a Customer to answer 1-7. If they answer multiple times
(such as 1, 3, and 7) they would create three records in the table as such:

5 | 1
5 | 3
5 | 7

I need to create a new table that combines all answers for each particular
Customer ID so that the single records would look like:

5 | 1 3 7

I know there has to be a simple solution that is eluding me and would
appreciate any help. Thank you in advance,

Jack
 
Use a CrossTab query (the wizard will help you build it).

CrossTab queries can't directly be used to make a table but they can be used
indirectly. Once the CrossTab is built, create a Make Table query that
utilizes your CrossTab.
 
Thank you for all the help everyone. I basically formed a CrossTab Query
with Customer ID as the Row Heading, Response as the Column Heading and the
Value (using AVG as the Total on the Value). THis gives me a copyable
spreadsheet that I could easily paste into Excel and concatenate the Value
fields into one.

Thanks again,
Jack
 
Back
Top