Hello everyone,
I have a query that I run once a month to show any records from the past 12months/year/365days from a given date. Currently I'm using this criteria: >=#1/1/2015# And <=#12/31/2015#.
Ideally, I'd like to be able to specify/enter the date and have it use that to show any records from the last year (365 days) from that date.
does that make sense? If entering a date makes it too difficult, is my current criteria my best option?
Thank you for all of the help!