I am using Access 2010 and have a linked table of Cost Code values and each cost code can have one or more Cost Type values. The linked table is a spreadsheet from our main ERP.
I would like to have a report that shows all cost types for each cost code.
e.g.
Cost Code Cost Type
.00.00.0.01 E, L, I
.00.00.0.02 E, L, M
.00.00.0.03 E, M, I, S
.00.00.0.04 I
Can someone please help me get started on how I can accomplish this?