String Email

[buzzboychicago]

If I have a table that has and AccountID and an Item, and I have multiple items per account ID for instance

Account ID Item
2453 ProductTypeA
2453 ProductTypeB
2453 ProductTypeC


How do I get the list of those product types into an email string? I don't know where to begin because any given Account ID might have more or less items than the next.

Thanks for any help...

 

[buzzboychicago]

Maybe this makes more sense...

How do I get a table that looks like this...

12333 IceCream
12333 Apple
12333 Orange

23442 Butter
23442 Milk
23442 Raisins
23442 Dates

to look like this

12333 IceCream, Apple, Orange
23442 Butter, Milk, Raisins, Dates

 

[PHV]

You have to play with a Recordset.
There is a FAQ about this topic in the Microsoft: Access Queries and JET SQL forum:

http://www.tek-tips.com/threadminder.cfm?pid=701

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886