Results 1 to 2 of 2
  1. #1
    gyull is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    1

    Post Crosstab Query Help?


    I have 10 clients that I work for. I would like to track how many jobs I do for each client per month. When I use a Crosstab Query I have the 10 clients names in rows and the Month in column headers with total jobs per month.....Brilliant. the problem is that the 'JAN' column has a total of all jobs over a 2 year period, I would like to split this by years (2014, 2015 etc). Any help is much appreciated, Thanks in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    Calculate a field that has the YearMonth as a value that can be used for the column headers.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-30-2014, 03:01 PM
  2. Replies: 2
    Last Post: 08-16-2013, 01:36 AM
  3. Crosstab query
    By Deutz in forum Queries
    Replies: 2
    Last Post: 08-23-2011, 06:43 PM
  4. Crosstab Query Bug
    By goodguy in forum Queries
    Replies: 19
    Last Post: 02-03-2011, 01:41 PM
  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