Tracking Time via Manual Input

[2D Rick]

Using XP and Access2003:
I'm trying to track furnace downtime.
Operators will enter the downtime date and time manually but it could
be entered some time after the furnace goes down.
I can give them an activeX calendar to choose the date but how do I get
them to enter the exact(ish) time the downtime occurred?
Once I have the date and time in their respective fields, How do I
combine Date & Time so their value can be used to calculate how long
the furnace was down?

TIA, Rick

[Ed Robichaud]

Look at the "general" date/time format that displays both in the
field/control and permits data entry of both. Use the DateDiff function to
calculate duration between your stop and start values. Defaulting to
"Now()" will enter both date+time. Entering just the date (like Date()
does) using an implied time of midnight.
-Ed
"2D Rick" <rb*******@compuserve.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

Using XP and Access2003:
I'm trying to track furnace downtime.
Operators will enter the downtime date and time manually but it could
be entered some time after the furnace goes down.
I can give them an activeX calendar to choose the date but how do I get
them to enter the exact(ish) time the downtime occurred?
Once I have the date and time in their respective fields, How do I
combine Date & Time so their value can be used to calculate how long
the furnace was down?

TIA, Rick

[2D Rick]

I see where this would work if I was using the default time and date
but the operator might not enter the downtime untill later in the day
and not at the actual downtime.
If I missunderstood you, please clarify.
Thanks for the quick reponse,
RICK

[Ed Robichaud]

I was suggesting using just one data entry control for both time and date.
Set the field/control format to "general date"
and use the input mask:
99/99/00\ 99:00\ >LL;0;#
to permit users to data enter "0303061015am" and have it displayed as
03/03/2006 10:15 AM

All this assumes that you're trying to log durations over more than one day.
You could, of course, enter separate date+time, but that makes counting down
time a bit more complex.
-Ed
"2D Rick" <rb*******@compuserve.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

I see where this would work if I was using the default time and date
but the operator might not enter the downtime untill later in the day
and not at the actual downtime.
If I missunderstood you, please clarify.
Thanks for the quick reponse,
RICK