From Rows to Columns

[Guest]

Hi, I really do hope that someone can help me. I am copying information from
Access and pasting it into Excel to compile a report. I have to present a
report in the following format-:

Name Net Pay Pensions CELL ALLOWANCE
Charmaine 70,000 4,000 2,000
Akena 60,000 3,000 1,000

But this is the format of the Data in Access. Does anyone know how I could
transform the under mentioned into the aforementioned. Thank you.

First_name Desc Amt
CHARMAINE TRAVELLING $4,385.49
CHARMAINE Basic Salary $80,000.00
CHARMAINE PENSIONS ($4,000.00)
CHARMAINE CELL $4,000.00
CHARMAINE REFUND $2,000.00
CHARMAINE COLA $480.00
CHARMAINE NET PAY ($70,303.24)

 

[Guest]

Use a crosstab query.

 

[PC Datasheet]

If you are using Access2000 or higher, look at Pivot Tables in the Help
file.

 

[PC Datasheet]

A crosstab query won't do it because a crosstab query only allows you to
pick one field for the columns.

 

[Guest]

WRONG in that DESC is one field!

A crosstab query won't do it because a crosstab query only allows you to
pick one field for the columns.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)

 

[PC Datasheet]

Yes, you are right; I should have looked closer. I saw Net Pay, Pensions and
Cell Allowance and blindly thought they were different fields. Thanks for
the correction!!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)