does anyone know why when subtracting two numbers entered and stored with one decimal point the outcome can have a whole bunch? e.g 11.2 - 8 = 3.19999980926514
I have to jump through hoops to get it back to 1 decimal e.g. CDbl(Format((Nz([tbl_TE].[End_Time],0)-Nz([tbl_TE].[Start_Time],0)),'#.0')) AS Hours
when it should be end time - start time = hours.
thanks in advance