This might be a stupid question but I've been banging my head against a wall for an easy solution to this problem. In Access, I'm working from a table someone else built that contains comments for work orders. Some work orders have several lines of comments, but instead of them falling under seperate column headings they are set up like this.

WO_________COMMENT_____GEN_ARG
37000202____Comment1_____10000
37000202____Comment2_____20000
37000202____Comment3_____30000
37000203____Comment1_____10000
37000203____Comment2_____20000

and so on.

All I want to do is concat all the comments for each work order into one field. I have another table with other information on each work order(dates and such) and I'd like to just dump the concatonated comment into that table. Any ideas on an easy way to do this?

Why do it in a query? It's easy to group the comments in a form or a report. Won't that do?