Combining values in several records into one

TNilles

Guest

Posts: n/a

11th Nov 2008

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

« Access 2007 can Add Database to SourceSafe | to ja »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining values from several records into one record	Duck	Microsoft Access	1	7th Jul 2009 03:11 PM
combining records	=?Utf-8?B?a2xubWlz?=	Microsoft Access Queries	1	26th Jun 2006 09:28 PM
Combining records	=?Utf-8?B?U3RldmUgWQ==?=	Microsoft Access	4	17th Apr 2006 09:55 PM
combining records with some identical values	=?Utf-8?B?UGF1bEZvcnQ=?=	Microsoft Access Getting Started	0	10th Sep 2004 12:47 AM
Query combining multiple records from one table can't add records	Clint Marshall	Microsoft Access Queries	4	8th Jul 2004 01:25 PM