Combine multiple values horizontally in a report (text) field

[FinanceDude]

I have a query with say 5 zip codes and I want to list them in a report horizontally (on a single row). For example the output = "21043, 23942, 21286, 12345, 98765".

How can I do this? I've been playing with text field but had no luck. Any assistance would be much appreciated!

 

[GingerR]

Hi there--This isn't something you can do in queries. You'd have to write code to loop thru your table and concantonate the data. Here's a post where it shows someone who's written something you could use. So try it out and see if it works for you!

thread703-947026

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244