Combining text fields for duplicate records

[lwilt]

if I had a table that looks like:

email	custome number	apples	trees	sports	ice cream
abc@yahoo.com	123	Y	Y		Y
abc@yahoo.com	126
123@gmail.com	858	Y
123@gmail.com	767		Y	Y
owow@yahoo.com	444	Y
owow@yahoo.com	455
999@yahoo.com	1001	Y			Y
999@yahoo.com	1103			Y

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Is there a way in access to combine the responses so that each email has the 4 answers combined into their own seperate fields that way there isn't dup emails and I don't lose any of the responses?

 

[Gingertrees]

Export to excel? It's pretty straightforward in Excel.

 

[lwilt]

I figured that's what I would have to do...I assume the only way doing it in excel would be writing a macro correct?

 

[Gingertrees]

You can probably also do a CSE (array) formula in the worksheet, but I'd pick VBA.
Are you looking for an unduplicated email list, such that for example, an email includes the following?
abc@yahoo.com: subject = customer 123, 126; body = apples, trees, ice cream
123@gmail.com: subject = customer 858, 767; body = apples, trees, sports

 

[Gingertrees]

Caveat: you may wish to send an email to each customer number, even if it means some people get 2 emails. You'll want to trace correspondence to customer #s, so I think that part may be unavoidable. However, combining apples, trees, etc. is pretty easy.

 

[lwilt]

I'm trying to just end up with:

EMAIL Apples Trees Sports Ice Cream
abc@yahoo.com Y Y Y
123@gmail.com Y Y Y

The customer numbers ultimatly won't matter because I'm in the process of cleaning the db to fix that but just need a band aid solution to this problem for right now

 

[lwilt]

it messed up the spaces for the Y's but I think you follow what I'm trying to get to

 

[lwilt]

Oh and I forget to mention one other thing...it is actually 17 different "questions" I would like to combine at each email so I'm just trying to figure out how to get it started

 

[Micron]

if I had a table that looks like:

Looks to me like your proposed table follows the spreadsheet mentality, which is not how tables should be laid out. If you had a table of 'categories' with apples, trees, sports, ice cream, etc. as values, it would be more normalized. What you are doing is putting row values into columns, which is not the way it should be (also creates a lot of holes). If you normalized it more, you should be able to create a crosstab query, but I don't think you can with what you have.

<tbody>
</tbody>

 

[Gingertrees]

This was recently solved on another thread I worked on (though I did not craft the solution). Check this out:
http://www.mrexcel.com/forum/excel-...-rows-into-one-visual-basic-applications.html