View Single Post
Old February 15th, 2005, 11:39 PM
Bob Bedell Bob Bedell is offline
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Also, if "2mn. 13sec." represents some sort of elasped time value, a better design might be to store an actual staring time value and ending time value in two Date/Time datatype fields (which would give you actual time values to work with), then calculate the elapsed time value in a query and format the time values there (though the custom format would still require treating the time value as a string in code somewhere so you could append the custom "mn." and "sec."
 suffix strings).