update query confusion

[cporter]

I have a formula that works fine in a select query:

SELECT (([dayup]+[timeup])-([daydown]+[timedown]))*24 AS HD,
WORKORD.DAYDOWN, WORKORD.TIMEDOWN, WORKORD.DAYUP, WORKORD.TIMEUP,
WORKORD.MACHID, WORKORD.WONO
FROM WORKORD;


That gives me my time down in hours like I want. When I try and use
this in an update query as below it drops off the fractional parts.

UPDATE WORKORD SET WORKORD.THD =
(([dayup]+[timeup])-([daydown]+[timedown]))*24;


Any ideas on how I get this to work?




Space separated data:

DAYDOWN DAYUP TIMEDOWN TIMEUP MACHID EMPLOYEE ACTION REQUEST COMMENT1
COMMENT2 WONO THD SUBSYS
11/3/1998 11/3/1998 8:00:00 8:20:00 APT-006 KPM PM PM none none
34743 0.00
11/8/1998 11/8/1998 13:00:00 13:15:00 APT-014 RC PM PM none none
34745 0.00

 

[Douglas J. Steele]

What's the data type of field THD?

 

[cporter]

It's data type is number and the other settings are double, fixed, & 2
decimal places. I've tried others settings as well.