Calculations between date and times

[Hemish]

Hi,

In MS Access i'm trying to calculate the difference between one date time to another. for example

26/04/2007 09:00 am
07/03/2007 10:30 am (Current date time)

This should work out the:

days
hours
minutes
seconds

I did want this to be shown on a form

Thanks

 

[GaryPanic]

do a search on time - this has been asnwered recently (within 14days)

 

[namliam]

Just substract the 2 dates. The integer of the result is the number of days. The decimal is the number of hours/minutes.

Greets