rounding off numbers in queries

  • Thread starter Thread starter ash
  • Start date Start date
A

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
 
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.
 
Back
Top