Results 1 to 3 of 3
  1. #1
    fountain27 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Apr 2019
    Posts
    25

    Crosstab Query

    I have a one query show sales by month by payment method. I then created a crosstab query to summarize everything by month for each payment method. However, now I want to create a column comparing 2020 vs 2019 for each payment method. Below is an example:

    Month Cash Sales 2020 Cash Sales 2019 Difference Credit Sales 2020 Credit Sales 2019 Difference
    January
    February

    How would i get this so I can create a report?



    Thank you for any suggestions.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    The easiest way is to create two crosstabs, one for each year. Then use a third query to join these two on month and do your difference calculations

  3. #3
    fountain27 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Apr 2019
    Posts
    25
    Quote Originally Posted by Ajax View Post
    The easiest way is to create two crosstabs, one for each year. Then use a third query to join these two on month and do your difference calculations
    Thank you!!

    I cannot believe I did not think of the simple way.

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

Similar Threads

  1. Replies: 4
    Last Post: 12-19-2019, 12:23 PM
  2. Replies: 8
    Last Post: 05-11-2017, 07:54 AM
  3. Replies: 2
    Last Post: 04-30-2014, 03:01 PM
  4. Replies: 2
    Last Post: 08-16-2013, 01:36 AM
  5. Replies: 1
    Last Post: 07-30-2010, 10:28 AM

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