RE: t-and-f: Access

2001-08-06 Thread John Dye
eidenstrom > >Sent: Sunday, August 05, 2001 9:36 AM > >To: [EMAIL PROTECTED] > >Subject: t-and-f: Access > > > > > > > >On Sat, 4 Aug 2001 06:43:28 -0400 > >"John Dye" <[EMAIL PROTECTED]> wrote: > >Subject: RE: t-and-f: Access >

RE: t-and-f: Access

2001-08-04 Thread John Dye
> >Instead, you might consign access and other packages > >like it to the nearest long-drop and do the job in a > >fraction of the time using a simple line editor and > >DOS batch file. And how is your Model T Ford holding up these days? John Dye [EMAIL PROTECTED] DyeStat - www.dyestat.com

RE: t-and-f: Access

2001-07-30 Thread John Dye
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 >

RE: t-and-f: Access

2001-07-30 Thread Ben Hall
Using the standard datatypes that come with Access I doubt you'll be able to do what you want to do. Probably the best thing to do is create a char(8) field and apply a validation rule to it that validates the input as dd:dd.dd (d's are digits). The rule might start as "Like "??:??.??"" and you