rounding off numbers in queries

[ash]

hi all,
i use the following SQL statement to base my subform
information on:

SELECT DISTINCTROW [Order Details].*,
CLng(nz([Quantity]*[UnitPrice])*100)/100 as [Line Item]
FROM [Order Details];

the value of the Line Item is rounded, for example,
1989 * 4.10 = 8154.90, but it is saved and displayed as
8155.

how can i change it so that it's stored as 8154.90?
thanks for your help.

ash

 

[Duane Hookom]

What do you mean by "saved"? There is nothing in the query that
saves/updates any values. There is no reason to store or save the result of
a calculation like this.