Combining values in several records into one

T

TNilles

Access 2003
I have a table with the following fields in a record:
RefID#
Game#
RefType
Each game# will typically have 2 or more records (differenty reftypes)

I want to create a query/report that will combine the reftypes into one
record:
Game #
RefID# for Reftype 1
RefID# for Reftype 2
RefID# for Reftype 3 etc.

Other info will be added but I think I can handle that part. Any suggestions?

tia
 
Top