Hello experts. I inherited a problem in a database that tracks safety incidents. User inputs data from a form that is handed in. the issue is with the medium time format.
Table consist of,
Data Type: date/Time
Format: Medium Time
Input Mask: 99:00\>LL;0:# this is the Microsoft default.
The table seems to only be allowing "PM" times only?
whenever I input an AM time I get an error
"One or more values are prohibited by the validation rule'[when-time]' set for table......
Seems like an easy fix
This is not my database and data entry is direct table entry. Just trying to help a coworker out.
I could redo this using forms but just looking to get her by for now.
Thanks
Table consist of,
Data Type: date/Time
Format: Medium Time
Input Mask: 99:00\>LL;0:# this is the Microsoft default.
The table seems to only be allowing "PM" times only?
whenever I input an AM time I get an error
"One or more values are prohibited by the validation rule'[when-time]' set for table......
Seems like an easy fix
This is not my database and data entry is direct table entry. Just trying to help a coworker out.
I could redo this using forms but just looking to get her by for now.
Thanks