Time

[Mike]

I'm trying to get a field in one of the tables that has
Time property's but is not limited to 23 H and 59 m.
Example: A job takes 50 hours and 30 min but the ^$^%$&
Progame doesnt let me input that PLS help

Mike

 

[Arvin Meyer]

50H is not time, but an interval. Intervals of any kind (even less than 24
hours) should not be stored in a date/time field. You can store the start
time and end time (which, btw, includes the date) or you can use a double to
store the interval.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access