storing time values accurately

[Mike Whitaker]

I'm trying to store time values down to tenths of seconds, and at the moment
struggling to work out the best way of doing it. The end result has to be
that I can compare two times & get the difference.

At the moment I'm recording the time from the Now() function.

Is there a more accurate way of doing this?

Im am working with an Access front end with either Access 2002 tables or and
SQL backend.

Cheers,

Mike

 

[Rick B]

Do a search. Asked and answered all the time. You can't do this with the
built-in Access time data type. You will have to store this as a number, or
three separate numbers.

Read the previous posts for more details.

 

[Duane Hookom]

Depending on your requirements, I would consider using numeric double and
record the number of seconds.