Results 1 to 2 of 2
  1. #1
    kgav1 is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2009
    Posts
    4

    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 -

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums