Multiple records into 1

[peglegs]

I have a MS Access database table with 2 fields: File Name and Category. File names currently have from 1 to 6 categories. How can I create a recordset that shows the file name and a new field "Categories" that is a concatenation of that file name's categories resulting in a unique value for the file name?

For example: 5 records become 2 records
File Name Category
Direct Deposit Form Financial
Direct Deposit Form Payroll
Direct Deposit Form FAC
Orientation Checklist Checklist
Orientation Checklist Subcontractor

Becomes
File Name Categories
Direct Deposit Form Financial, Payroll, FAC
Orientation Checklist Checklist, Subcontractor

Help is very much appreciated. Thank you.

 

[Chyld]

Hi there peglegs, I aint no expert and don't pretend to be, but what would you want your info in that format for?

 

[peglegs]

We have a very large master index of documents and people have a hard time knowing where to find things. So we have created various categories that can serve as keywords. I want to show them what else a document may be classifed as.