Dividing in Access 2000

J

John Vinson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top