View Single Post
 
Old February 15th, 2005, 11:24 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
Default

Actually what you're attempting to store here, and what your users are entering, are simple string values, not time values as time values are understood by Access (8-byte floating point numbers).

You would need to write a little string parsing routine to locate the semi-colon in your string (e.g., Instr (1, "2:13", ":")), then parse off the characters strings to the right and left of the semi-colon, and append "mn." and "sec." respectively to the two sub-strings.

If I get some time I'll give it a whirl.

Bob