I am trying to round up in a query. If I have a 'Count' of 3 and a 'Box Qty' of 5 the answer using the formula below is 5 (true)
This works unless the 'Count' is the same as the 'Box Qty' in which case 3 rounds up to 6.

Qty Rounded: (Int(([Attribute_Table]![Count]/[Fixtures_Table]![Box Qty]))+1)*[Fixtures_Table]![Box Qty]

If I take away the +1 it rounds down

Can anyone help?