-
Help with a query
I have data in 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 -
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules