Hi. I need help with a Query. When I click to open a report I need a parameter to ask for a date to be entered and then it would pull anything for that date plus the previous three months. Thanks.
Hi. I need help with a Query. When I click to open a report I need a parameter to ask for a date to be entered and then it would pull anything for that date plus the previous three months. Thanks.
Is there ever any future dates in your data?
If not, you should be able to just use this in your Criteria:
Code:>=DateAdd("m",-3,[Enter Date])
This is giving me future dates and previous dates too far back.
For example: I enter date 07/31/16, it's giving me from 04/30/16 through 08/10/16
I want it to give me all of 05/01/16 through 07/31/16
Yep, that is why I asked if you had any future dates, in hopes to use a simplified formula.
Just a little more complex, try this:
Code:Between (DateAdd("m",-3,[Enter Date])+1) And [Enter Date]
Awesome, this works great. Thank you so much.
... Misread question so deleted