Conernesto
asked on
Access move rows to columns
I have a query named RandSt_byState_qry. The query has the following fields:
StDescr_1 (this is a field name)
StateAmount1 (this is a formula)
StDescr_2 (this is a field name)
StateAmount2 (this is a formula)
Is there a way to get all the above as follows via a new query? I want all the contents of the first two items above in two columns and the last two items below the first two items.
Have:
StDescr_1 StateAmount1 StDescr_2 StateAmount2
Want:
StDescr_1 StateAmount1
StDescr_2 StateAmount2
StDescr_1 (this is a field name)
StateAmount1 (this is a formula)
StDescr_2 (this is a field name)
StateAmount2 (this is a formula)
Is there a way to get all the above as follows via a new query? I want all the contents of the first two items above in two columns and the last two items below the first two items.
Have:
StDescr_1 StateAmount1 StDescr_2 StateAmount2
Want:
StDescr_1 StateAmount1
StDescr_2 StateAmount2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER