Link to home
Start Free TrialLog in
Avatar of Conernesto
ConernestoFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Conernesto

ASKER

Thank you very much.