Using Date in Access

[ricyac]

I'm fairly new to using Access, but what I want to do is have a query where I can separate data that was entered a year or 12 months from the current date. I want to then have a report that continually updates this information. I know how to build the report from the query, but now I just need to know how to set up the criteria. Any help? Greatly appreciated!

[pbaldy]

Try something along the lines of:

Between Date() - 365 And Date()

You can also use the DateAdd() function instead of simply subtracting days.