There are a number of ways to calculate the time between two dates in Access. You can use a calculated field in a query, a calculated control in a form or report, or you can use a VBA procedure to perform the calculation. If you need to calculate the number of days between two dates, the syntax is: =[One date field] – [Another date field] You can use functions to calculate the number of years between two dates: =Year([One date field]) – Year([Another date field]) You can also use the DateDiff() function, which uses an argument to determine how the … Continue reading →