Time Code Format

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

Guest

This is a bit of a specialist question. I want to store PAL video time code
(hh:mm:ss:ff, ff= frames, e.g. 01:13:45:23) as data in my table. Has anybody
ever heard of way to format time code in Access?
 
This is a bit of a specialist question. I want to store PAL video time code
(hh:mm:ss:ff, ff= frames, e.g. 01:13:45:23) as data in my table. Has anybody
ever heard of way to format time code in Access?
Click to expand...

I'd suggest storing it either in two fields - Long Integer seconds and
integer frames, using an expression to concatenate it together; or
(probably less desirably since it's not really an atomic field) as a
Currency datatype with seconds to the left of the decimal point and
frames to the right.


John W. Vinson[MVP]
 
If you want to do queries such as "between frame 01:13:45:23 and frame
03:21:10:22", it's probably simplest to convert it into frames and store
the result in a Long number field.

If you're not going to search or do arithmetic on these values, you
could just store them in text fields.
 
Back
Top