Formating time for just minutes and seconds

[Poobear1929]

I am trying to format a feild in a table that will accept only minutes and seconds. Like a stop watch. I need access to see the values as minutes and seconds so I can do calculations in other parts of my database. I tried the nnss like the helpl file suggested, but when I input a time of 12:30 in the field it sets to 00:00. If any one can help it sure help me out a lot.

 

[Trendsetter]

I tried the nnss "
If you miss out the : the field will be text.

You can use the defaults in the properties page and cut it down to what you want.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk