I have an Access query with an expression to pull data for the past 3 years plus the current year:
year(date())-3 or year(date())-2 or year(date())-1 or year(date())
I would like to change this expression so I can pull all of the prior years' data but only a portion of the current year. For example, 1Q, January through March.
Is there a way to do this?