Results 1 to 3 of 3
  1. 12-24-2018, 04:29 PM #1
    Boomkweker
    Boomkweker is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2018
    Posts
    2

    Report based on crosstab query with criteria last year and the year before


    On a crosstab query i want to filter year 2018 and 2017 and next year 2019 and 2018. Is this possible with criteria in the query design matrix
    Reply With Quote Reply With Quote
  2. 12-24-2018, 04:58 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,973
    Should be. Review http://allenbrowne.com/ser-67.html
    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.
    Reply With Quote Reply With Quote
  3. 12-24-2018, 05:12 PM #3
    isladogs's Avatar
    isladogs
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,992
    Filter criteria = Year(Date) or Year(Date)-1.
    Suggest you apply to the source query before crosstabbing
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Database set up year by year with only reporting for current year.
    By ewfranz in forum Database Design
    Replies: 2
    Last Post: 04-19-2017, 01:09 PM
  2. Crosstab Fiscal Year on Year Query
    By DJF in forum Queries
    Replies: 1
    Last Post: 02-07-2017, 09:27 AM
  3. Report comparing this year and last year's data
    By cechopin in forum Reports
    Replies: 3
    Last Post: 06-13-2016, 03:26 PM
  4. how to select month+year based on current year in VBA
    By accessLearn in forum Forms
    Replies: 4
    Last Post: 07-13-2015, 02:06 PM
  5. Year to Date Last Year - need query based on date field.
    By jasonm in forum Programming
    Replies: 7
    Last Post: 06-07-2015, 11:57 PM

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

Other Forums: Microsoft Office Forums