You can do this in a query but it'll be an ugly formula, it would have to have every possible unitID in the formula and I don't how possible that is with your dataset, I think I'd be more inclined to just use a crosstab query.
First step would be this:
Code:
SELECT YP.MeetingID, YP.MeetingNum, YP.MeetingDate, YP.CountID, tblUnits.UnitName, YP.RateFixed
FROM tblYarnPricingMeeting AS YP LEFT JOIN tblUnits ON YP.UnitID = tblUnits.UnitID;
Save this as QUERY1 (NOTE I changed your meeting# to meetingnum, using special characters in field names is a bad practice and will only cause problems with your coding)
next make this query
Code:
TRANSFORM Count(Query1.CountID) AS CountOfCountID
SELECT Query1.MeetingNum, Query1.MeetingDate, Query1.RateFixed
FROM Query1
GROUP BY Query1.MeetingNum, Query1.MeetingDate, Query1.RateFixed
PIVOT Query1.UnitName;
It will list rows for every unit type you have which may be more useful to you than having it concantentated. If you really must have it concantenated then you would write a new query based on the crosstab query (the second query) that would contcantenate the fields.
I've never found a reason to do this type of concantenation so someone may have a sleeker solution