write time

[Guest]

Hello,

I have a database in which I am adding up time eg 3:13 ,2:15 however the
time is manually inputted. My problem is that access is not recognizing my
data input as duration there they cannot be added is there anyway I can fix
this?

Thanks

 

[Jerry Porter]

You could try converting your data to date/time format before adding it
using the CVDate function. For example, if you now have Duration1 +
Duration2, you could use CVDate(Duration1) + CVDate(Duration2).

On the other hand, if your data were entered into a table, and the
field was designated as date/time, this wouldn't be an issue.

Jerry

 

[RuralGuy]

Hello,

I have a database in which I am adding up time eg 3:13 ,2:15 however the
time is manually inputted. My problem is that access is not recognizing my
data input as duration there they cannot be added is there anyway I can fix
this?

Thanks

See if this link helps.
http://www.mvps.org/access/datetime/date0009.htm
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.