simple calculation in a query

  • Thread starter Thread starter SylvieB
  • Start date Start date
S

SylvieB

In a query, proposalAmount and ordervalue are in thousands of dollars. How
can i convert the ordersomme to million instead of thousand to show on the
report?
Here is the code i wrote which works fine in thousand:
ordersomme: IIF[(proposalAmount] is null, [ordervalue], [proposalAmount])

I tried to add /1000 but it won't work.

Thank you in advance for any help.
Sylvie
 
Back
Top