435,446 Members | 3,120 Online
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

# Comparing quarterly sales data to previous quarter and previous year.

 P: n/a I have created a query that examines qarterly sales for 5 regions in the country. The query contains data for the past 6 quarters for each region and calculates the perecentage of total sales for the quarter fo each region. To help enhance the report I would love to include a comparison to of current sales to previous quarter sales and a comparison of current sales to sales a year ago. I am having a devil of a time creating a query to perform those actions. I am not skilled at VBA and was hoping someone could provide me with the code that will make the comparisons. Below is the all of the data in my query. Your help would be greatly appreciated!! Quarter Region SumOfSALES SumOfSumOfSALES Percentage 2003 1Q Central 199309.65 735107.03 27.11% 2003 2Q Central 240177.63 831601.9 28.88% 2003 3Q Central 245502.85 816521.33 30.07% 2003 4Q Central 136540.24 533517.93 25.59% 2004 1Q Central 114608.1 546407.99 20.97% 2004 2Q Central 119156.12 539942.9 22.07% 2003 1Q NE 124915.62 735107.03 16.99% 2003 2Q NE 139753.83 831601.9 16.81% 2003 3Q NE 136735.48 816521.33 16.75% 2003 4Q NE 90414.14 533517.93 16.95% 2004 1Q NE 80012.9 546407.99 14.64% 2004 2Q NE 94615.41 539942.9 17.52% 2003 1Q SE 215673.22 735107.03 29.34% 2003 2Q SE 242570.81 831601.9 29.17% 2003 3Q SE 235134.88 816521.33 28.80% 2003 4Q SE 179762.23 533517.93 33.69% 2004 1Q SE 182502.66 546407.99 33.40% 2004 2Q SW 179333.25 539942.9 33.21% 2003 1Q SW 62762.27 735107.03 8.54% 2003 2Q SW 63238.55 831601.9 7.60% 2003 3Q SW 68552.6 816521.33 8.40% 2003 4Q SW 61301.1 533517.93 11.49% 2004 1Q SW 113640.5 546407.99 20.80% 2004 2Q SW 85152.37 539942.9 15.77% 2003 1Q West 132446.27 735107.03 18.02% 2003 2Q West 145861.08 831601.9 17.54% 2003 3Q West 130595.52 816521.33 15.99% 2003 4Q West 65500.22 533517.93 12.28% 2004 1Q West 55643.83 546407.99 10.18% 2004 2Q West 61685.75 539942.9 11.42% Nov 13 '05 #1