milliseconds??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing Swimming School Database

There are two tables:

STUDENT (sid, fname, lname,...)
RECORD (sid, rid, rdate, rtype, rdist, rtime)


My Client asks to show Students' information along with their Record Graph
in a report.

Record time is needed to save minutes, seconds and milliseconds like
01"03"23".

I am using Pivot Chart to show the graph, but not sure which data type have
to chose for rtime since date format only shows until seconds and text/number
type have some issues with scales.

Any ideas?


Thanks in Advance :)
 
Record time is needed to save minutes, seconds and milliseconds like
01"03"23".
Should not you need three places for milliseconds like this 01"03"023"?
I would suggest using three field - minutes, seconds, and milliseconds.
Then calculate to use in your graph like this --
MilSec: ((([minutes]*60) +[seconds])*1000) + [milliseconds]

This converts minutes to seconds, adds that to seconds, multiplies by 1000
to acheive milliseconds, and adds to the milliseconds field value for total
in milliseconds.
 
Back
Top