Transposing data

[Tammy]

Hello,

I wasn't sure which group in Access to post this to, so I'm starting here...

My user would like to take her data in the table below and have it display
as indicated in her query results below. Can anyone give us some suggestions
on how to go about this?

We are using Access 2007.

Table:

ID Name Gift date Gift amt
Gift acct
0001 John Doe 1/1/2007 $50
Annual Fund
0001 John Doe 1/1/2008 $75
Dean’s Fund
0001 John Doe 1/1/2009 $60
Annual Fund

Query results:

ID Name GiftDate1 GiftAmt1 GiftAcct1 GiftDate2 GiftAmt2
GiftAcct2
1 John Doe 1/1/2007 $50 Annual Fund 1/1/2008 $75 Dean's
Fund

Thanks for any suggestions!

 

[Duane Hookom]

Is a report a possibility? If so, you can create a multi-column report to
display the results. If you really think you need a query, you would first
need to create a ranking query and then create a multi-value crosstab from
the ranking query.

 

[Tammy]

Hi Duane,

Thanks so much for responding.

I think a report would work, as well. I'm not sure how to get the individual
records to display in fields with "new names": example, the field in the
table is called "Gift amt" - in a report, how would I then display record 1
as "Gift amt 1", record 2 for the same name to display as "Gift amt 2", etc...

Same thing for the "Gift date" and "Gift acct"...

Each "name" can have more than one gift date, amt, and acct.

For each record, display the date, amt and acct under new lables - if
someone gave three gifts, I would need Access to create columns called "gift
date 1", "gift date 2", "gift date 3" (and "gift amt 1", gift amt 2", gift
amt 3" - as well as the gift accts).

I hope I'm explaing this well...

I wasn't sure what you meant by "ranking query" - if that sounds like what
I'll need, can you explain that one?

Thanks again, Duane!