Time field for calculating past midnight

[Tina N.]

There were some instructions on here but I didn't understand how to put the
date and time to calculate total minutes between the interval. I have two
fields in my data base. Time and then date for a set of 6 different numbers.
I want to have access calculate the differences between two times that may
occur on different dates. How do I do this?

 

[Ken Snell [MVP]]

You can add the date field and the time field together, and then use the
DateDiff function to calculate the difference between two date/time values.

ElapsedMinutes = DateDiff("n", [DateField1] + [TimeField1], [DateField2] +
[TimeField2])