Use DateDiff and DateAdd to subtract and add Date/Time values.
This video is part of a training course called Query criteria 2: Using date criteria in queries. You can download the entire course or watch the videos online:
Need a reminder of what you learned? See the course summary.
Ready for another tutorial? See the complete list of Access 2013 training courses.