Time Problem

[Guest]

Forgive the repost but I want to formulate my question a little better. I
have a form called RN Notes that records nursing notes during invasive
cardiac procedures. At times, a nurse will omit an entry and need to go back
and enter in the time and indicated nursing note. My form has a field for
time and another for RN notes. When the RN needs to enter an omitted note
he/she needs to go to an new record, change the time and enter the note. The
probem is then the note is not sorted appropriatley, i.e., time ascending.
When I go back and look at the table data I noticed that the hand entered
times are stored as ##:##, but the system entered times (default = Now()) are
stored as full date and time.

Is there a way to store system times in the simle ##:## format? Any ideas
how I might be able to remedy this problem. Thanks, Rob

 

[Douglas J. Steele]

If you're using Now in code, but they're strictly putting in a time, odds
are they're not including the date (which Now does).

Put logic in your form's BeforeUpdate event to check if the time field is
for the correct day, and change it before it's stored if it isn't.

 

[Guest]

Doug, thanks. The nurses would only be adding omitted notes on the same day.
I changed the formatt in the table and form to Time(). Do you think this will
work?

Robert

 

[Douglas J. Steele]

It might, but be aware that Access really doesn't handle Time very well: the
Date/Time data type expects a timestamp (a date and time), so if they start
working at 23:30 and continue to 02:00, you're not going to sort properly.