Problem with Format Function 1

[AlienX69]

#########################################################
First, would like to say THANKS to all the GREAT support folks here for taking the time to help n00bs like me.
#########################################################

Having a problem with the following in a qry:

Total Pipe Length (ft): Sum(Format([PIPE_LENGTH]/12,"0.00"))

All come out correctly except ONE (9379.76999999999). What even odder is if I totally remove the Format function, the value comes out as "9379.62729716667", very strange. Then I noticed another 7425.4 (see below) is actually "7425.537243" without the Format function, i.e.

Total Pipe Length (ft): Sum([PIPE_LENGTH]/12)

AREA_NAME FLUID_CODE PipeSize Total Pipe Length (ft)
90001P FP 4" 3
90001P FP 6" 7425.4
90001P FP 8" 2754.93
90001P FP 10" 9379.76999999999
90001P FP 12" 36302.97
90001P HWR 4" 3002.44
90001P HWR 6" 3771.88

Should I being using a different function, i.e. "Round" ? ?

Plus I guess while were at it, how do i get all the records to display .00 if number is WHOLE, i.e. 3 (see above) or 7425.4 display as 7425.40.

FYI: the reason for using Formating in the qry (in case anyone wonders) is I Export to .xls for the eng. design team. Using MS Access 2003 front-end to an Oracle db.


Regards
PUZZLED

 

[PHV]

Total Pipe Length (ft): Format(Sum([PIPE_LENGTH])/12,"0.00")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[AlienX69]

THX PHV ........ works PERFECT !!!!