Timing Error

[Guest]

I have a field (J) in my database that ='s the summing of 3 other fields and
I'm having trouble getting it to sum correctly. I subtact field A (date and
time) from field B (date and time) with the results in field C (hours and
minutes)(I have a VB code to get the correct format for hours and minutes),
with the same type of enteries in D, E, F, fields and G, H, I,.fields. When
I enter =C+F+I in the control source for field J, I get the 3 times in the
field, hours and minutes if I put =TIME DURATION ([FIELD C]+[FIELD F]+[FIELD
I]) in the control source I get #ERROR message

What am I doing wrong and am I going about it wrong.

 

[Guest]

Hi

Have a look at these links - hope it helps

http://office.microsoft.com/en-us/access/HA011102181033.aspx?pid=CH062526691033

http://support.microsoft.com/default.aspx?scid=kb;en-us;210604


--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.