Any Access gurus out there?

Plow needs help. I've got a table with Month, Year, Territory, Order#, and Comment fields. Territory and Comment are text. A query matches the Order# with another table & totals a value on that other table by the Territory. No problems yet. However, I want to comcatenate the comments for each territory into one entry. Anyone know how I can do this?

There's a SQL command called "CONCAT()" that should do what you want.

Check this out.

do you mean concatenate or group?

if you want to concatenate and output, you'll need to do some VBScript, if its just group then you need to use SQLs aggregate functions, say:

Code:

SELECT territory, comment
FROM TABLENAME
WHERE territory=@territory
GROUP BY territory, comment;

and enter the @territory value when prompted

I want to concatenate. I have comments that I want to make into one large comment based on territory. I think SQL is my best bet. Thanks.