This has got to be super simple and I'm going to waste someones time with this but I am missing something.
Query field: Month: Month([OrderDate])
Criteria: >=[Forms]![MainMenu]![Month]-3 And <=[Forms]![MainMenu]![Month]
Used to compare sales over the last 4 months.
When [Forms]![MainMenu]![Month] is equal to any number 2-9, the formula works as it should except that months 10, 11, and 12 are always included.
If the number is 1, it works as it should no problems.
If the number is 10 it only shows 10 ; 11 it shows 11 and 10 ; 12 it shows 12, 11, and 10.
Why is it doing this?