Dividing in Access 2000

  • Thread starter Thread starter doug
  • Start date Start date
how do I divide a number field by a time field in access
2000?

Ummm... what do you mean? What result would you expect after dividing
15 by 3:00pm?

A Time is stored as a Double Float number, a count of days and
fractions of a day since midnight, December 30, 1899. You can use
CDbl() to convert it to a double precision number for calculations,
but I don't know what the meaning of such an expression might be - a
time is a specific point in history, not a quantity!
 
Back
Top