A Time Problem
Posted on 1998-08-24
Because the type of elapsedTime in the table "Results" of my MS Access database is Date/Time, when insert a value into the field of elapsedTime, it will automatically add "AM" at the end.
For example: elapsedTime=00:30:10
After the elapsedTime is inserted into table "Results", you will see 00:30:10 AM in the elapsedTime field, not 00:30:10.
I can not change the type of the elapsedTime in table "Results" from "Data/Time" to "Text" because I need compare these values for ranking. Do you have a good way to solve this problem?