Calculating dates/times

[Shelby]

Is there any way to make Access calculate the difference
between two dates and times in a query, so that I could
track the turnaround time on something?

 

[Rick Brandt]

Is there any way to make Access calculate the difference
between two dates and times in a query, so that I could
track the turnaround time on something?

Check help for the DateDiff() function. It will return the number of "intervals"
between two date time values. You can choose what the interval is.

If you want something like 2 Years, 7 Months, 12 Days, 17 Hours and 15 Minutes. Then
you would have to create a custom function.