create 1 field from multiple records

[Keith S]

I have a table for sales and another for countries. There is one record for
a sale, but multiple countries in the country table that match the sale. Is
it possible to take the multiple countries and concatenate them all into 1
field?

In other words, I have a widget that was sold in the US, England, and
Canada. For the record I am creating in a query, can I a field that puts
those together as US, England, Canada.

Thanks for the help.