Reorganizing Table Data

[rileyma]

I'm very new to this forum, so I'm bound to make mistakes. My experience with Access as been selective. Rather than explaining what is needed, I'll provide a current state and the desired state:

Current State (table)
Description Line number Line description Dollar
Line 1 PO 1 1 Body Cost $1.00
Line 2 PO 1 2 Excise Tax $ .50
Line 3 PO 1 3 Sales Tax $.25
Line 4 PO 1 4 Sales Tax $.10



Desired State (table)

Description Body Cost Excise Tax Sales Tax 1 sales tax 2
Line 1 PO 1 $1.00 $.50 $.25 $.10

Can someone help me to get from the current state to the desired state without creating multiple make table queries?

Any help would forever make my life easier.

[June7]

Could try a crosstab query.

PO number field would be Row Header, concatenate Line Description and Line Number fields as Column Header, Dollar will be the aggregate field.

If Description includes "Line X" text then this is poor data structure. Line Number is a distinct field and info should not be repeated in Description. Need a field that has only PO number value.

[rileyma]

I just wasn't creative enough with the description. I'll give the crosstab.

Thanks

[June7]

This assumes Line Number for Body Cost is always 1 and Line Number for Excise Tax is always 2 and Line Number for Sales Tax always 3,4.