var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors