Time Code Format

[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?

 

[John Vinson]

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?

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]

 

[John Nurick]

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.