November 2, 200520 yr Newbies Hi, I am using version 8 on XP. I am trying to build a small DB to keep track my son's swim meet time results. The problem I have is that how do I define the TYPE of the field to hold time from swim meet. The data look like this 1.34.02 or 34.54. How do I compare which number is fatser than the other. Like on 1/1/2005 50 yard Freestyle. His time was 1:36.54 on 3/1/2005 50 yard Freestyle. His time was 55.36 How do I tell FMP that 55.36 is faster 1:36.54 Please hlpe. Thanks ;)
November 2, 200520 yr define your field as TIME and thus you will be able to subtract, compare (max/min), or even add (sum) the TIME. For your case, you may use to get the fastest time: TimeMin = Minimum(TIME) Edited November 2, 200520 yr by Guest
November 2, 200520 yr Adding to the other post, you can change the way time time stamp is formatted by going into layout mode, right clicking on the time field and selecting time format. This should work fine for fractional seconds comparisons too.
November 4, 200520 yr Author Newbies Sorry I had a problem with log in to reply to you Thank you very much for your help. It works
Create an account or sign in to comment