MS Access Rounding issue

Question

I have 3 values saleprice, productprice and reward_price. I need to have it look for saleprice first and if there is no saleprice then look at productprice. Then grab it and round it up or down by 50 cents. Soo..

4.49 = 4 reward_price = 4
4.50 = 5 reward_price = 5

Specifically, see [Remou's post here](http://stackoverflow.com/a/266745/334849) — LittleBobbyTables - Au Revoir, Mar 01 '13 at 19:51

score 0 · Accepted Answer · answered Mar 01 '13 at 19:57

SELECT
    Format(IIf(saleprice Is Null, productprice, saleprice), '#') AS reward_price
FROM YourTable;

Format() returns a string. If you need reward_price as an actual number, you can wrap the field expression inside a conversion function such as Val(), CCur(), CInt(), etc.

MS Access Rounding issue

1 Answers1