Update Query

[Guest]

i currently have a table that reads as follows:

AccountID - State - Jursidiction - Revenue
123456 - NJ - 1 - $456,256
123456 - NJ - 2 - $365,548
456789 - TX - 1 - $452,145
456789 -TX - 2 - $698,369
456789 -TX -3 - $452,874

Can a query be writen to transfer that data to a table that reads like:

AccountID - State - Jurisdiction 1 - Jursidiction 2 - Jurisdiction 3
123456 - NJ - $456,256 - $365,548
456789 - TX - $452,145 - $698,369 - $452,874

So I am essentially looking to take all AccountID and State pairing and make
a single record out of them.

Please reply with any questions, and thanks in advance for your help.

 

[Guest]

Hi,
Try to use the Crosstab wizard in Query. That should help you.