Datediff Function

Y

Yvette

How do I get this fuction to NOT round off to the nearest
hour????? in ACCESS 2000 (I'm tring to obtain exact total
hours)

I've tried:

DateDiff("m",[startdate],[enddate]))/60
or
DateDiff("nn",[startdate],[enddate]))/60

These do not work!!

I've also tired:

DateDiff("h",[startdate],[enddate])

This rounds to the nearest hours, and I need the exact
hours.
 
Top