Time Code Format

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?
--
Yo Yo Ma.

On Mon, 21 Mar 2005 19:45:03 -0800, "Murp"
wrote:

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]

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.

On Mon, 21 Mar 2005 19:45:03 -0800, "Murp"
wrote:

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 Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.