Concatenation of Access Fields.

[congamond]

Hello,



I have the following data:

Tax_ID Store_ID Last4_CC
1111 222 6789
1122 234 1234
1122 245 1234
1124 678 7890
1124 890 8900

A tax ID can have 1 to 1 or 1 to many stores and each store can have the same credit card number or each store could have their own credit card number. The output will break on a change in credit card number and/or store. I need to concatenate store_id in a new field if the credit card and tax id are the same, also capture the number of stores concatenated. like example 2.

Any help would be greatly appreciated.

Thank you, Brian

Report output needs to look like:


example 1.


Tax ID: 1111
Number of Stores: 1
Store ID: 222

example 2.
Tax ID: 1112
Number of Stores: 2
Store ID: 234, 245

example 3.
Tax ID: 1124
Number of Stores: 1
Store ID: 678

Tax ID: 1124
Number of Stores: 1
Store ID: 890

[June7]

Could just do report using Grouping & Sorting features with aggregate calc in group footer. Set up group on TaxID, StoreID in Detail section, Count(*) in group footer textbox. Otherwise, need VBA code. Review: http://allenbrowne.com/func-concat.html