Duplicate names in same row

  • Thread starter Thread starter DustWolf
  • Start date Start date
D

DustWolf

Hello,

I have a table that lists names and dates, where each name can appear
several times, each paired with a different date. I would like to make
a query which would list each name in one row, but add the dates
togather into a (horizontal) comma separated list.

Can this be done in a query? Or do I have to use VBA to pick data from
one table and dump it into another, temporary table?

Thanks for any help in advance. :)
 
Try the Crosstab query type and use the wizard if you're not familiar with
Crosstab queries.

However, based upon the number of columns it generates you could quite
possibly max out the X-tab queries capabilities.

Try outputting a select query to an Excel file and then use a pivot table to
generate the results.
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Combine Duplicates in Query 0
Excel Is this possible?? 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Updating tables when you input new data 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
do not duplicate date values in form 1
Document .mdb Table Fields, Type, Size 2

Back
Top