Sum bookings by quarter

[kgav1]

I data access database table where I have account bookings by quarter like the example shown below.


Quarter_Id Acct_Name Order# bookings
======= ========= ====== ========
q1 xxxx 234 $30
q1 xxxx 343 $15


q2 xxxx 222 $60
q2 xxxx 111 $20
q3 xxxx 112 $5
q3 xxxx 221 $6


Please help me with a query to get data where I show sum of dollars by quarter as shown below:


Acct_Name q1_bookings q2_bookings q3_bookings
========= ========== ========= ==========
xxxx $45 $80 $11


Thank you

Ven -

[pbaldy]

Have you tried the crosstab query wizard?

[kgav1]

Thank you.

It worked with using Crosstab Wizard

Ven -

[pbaldy]

No problem, and welcome to the site!