Rounding help needed

[smg]

I have the following formula:



Premium: IIf([Q2A]![E/NE]='N',([Q2A]![ByWkAccrual]/[Q2A]![SumOfCharged Hours])*0.5*[Q2A]![OT Hours],0)

I now need to add rounding to two decimal placess to this but I can't seem to make it work. Help. How should this formula read to accomplish rounding?

Thanks

[Micron]

You didn't say where to round (table, form control, expression...) nor did you say if the field (assuming there is one) is a number or text data type.

If table and numeric field, simply set the property sheet format value to fixed and the decimal places to 2. A report and form controls should show the rounded value.
If this has anything to do with $ you might want to investigate how Access rounds. IIRC there could be issues for you.

[smg]

query on numeric field(s)

[ssanfu]

I agree with Micron. If you do not understand the rounding methods, your numbers could be off (could be issues). There are Banker's Rounding, Rounding Up, Rounding Down, Round To The Nearest, ....

Remember that Rounding (unless you are storing the rounded number in a table) only affects the display of the number.




So, in a query, you could try

Premium: IIf([Q2A]![E/NE]='N',([Q2A]![ByWkAccrual]/[Q2A]![SumOfCharged Hours])*0.5*[Q2A]![OT Hours],0)              ' <<--  original


Premium: IIf([Q2A]![E/NE]='N',Round((([Q2A]![ByWkAccrual]/[Q2A]![SumOfCharged Hours])*0.5*[Q2A]![OT Hours]),2),0)   ' <<--  with rounding

[Micron]

Unless the source numbers (from tables) are long or integer type, decimal or single data type Access should be rounding up in your query or table. It does for me if I set Fixed and 2 decimal places in the query property sheet. Or perhaps try

Round(IIf([Q2A]![E/NE]='N',([Q2A]![ByWkAccrual]/[Q2A]![SumOfCharged Hours])*0.5*[Q2A]![OT Hours],0),2)

If that doesn't work consider posting a zipped copy of the db.

[smg]

Thank you all. I will try fixed, 2 decimal places and read up on MS Access rounding.