Access 2003 - dividing number is not giving correct value (rounding why?)
Posted on 2013-01-24
I have a simple query and I am mulitplying the LOT_SIZE*LOT_QUANTITY / LOT_PRICE so I can get a per unit cost.
Here is what I have tried:
SAMPLE DATA: 30 size with 11 quantity with cost of $3341.36 (answer should be $10.13)
I am using:
- I keep getting answer of 10. The system is rounding for me and I dont want it to.