Mutiple Records on a Single Line?

[RMCook]

I'm not sure this is something I can do in Access, but I'm hoping if it is someone can help me out.



I have a database of insurance policies, and each policy has one or more (six maximum) vehicles. When I query the database for policies based on certain (non-vehicle) criteria, I'd like to have the information for all vehicles associated with each policy appear in one row, instead of a separate row for each vehicle.

The query results would look like:

Policy Number, Year, Make, VIN
Policy Number, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN
Policy Number, Year, Make, VIN, Year, Make, VIN
Policy Number, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN
Policy Number, Year, Make, VIN, Year, Make, VIN, Year, Make, VIN
Policy Number, Year, Make, VIN, Year, Make, VIN
Policy Number, Year, Make, VIN

Can this be done in Access? Thanks in advance for any help.

[June7]

Review http://allenbrowne.com/func-concat.html