Break the minutes and seconds into different fields.
Convert everything to seconds for ranking purposes and then put it back in
minutes and seconds format for display and reporting purposes.
John Dye [EMAIL PROTECTED]
DyeStat - www.dyestat.com
Internet home of high school track & field & cc
> >-----Original Message-----
> >From: [EMAIL PROTECTED]
> >[mailto:[EMAIL PROTECTED]]On Behalf Of Miguel Goncalves
> >Sent: Monday, July 30, 2001 12:07 PM
> >To: t-and-f
> >Subject: t-and-f: Access
> >
> >
> >
> >Hi everyone,
> >
> >I am constructing a database for athletic performances in Microsoft
> >Access. However, I am having some difficulties to create a field for
> >the
> >long distance events. I want to create a field that allow to input
> >data on the format mm:ss.cc. The date/time default in access has
> >a hh:mm:ss, and nothing else. Does anyone tried to input athletics
> >data into access? Does anyone have a solution for this problem?
> >
> >Thanks,
> >Miguel
> >
