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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query? 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Mail Merge skipping records/sending one at a time 0
Combining three files when middle file has sections with endnotes 2
table design question 2
Combining values from several records into one record 1
Combining two review markings into one 1
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1

Top