I have a number field labeled QTY. I have another field labeled Final totals that looks at the QTY field and divides by 2. But if its a decimal i need it to round up to a whole number. For example...
Actually if you want to consistently round up you should use Ceil([Qty]/2) as Round([Qty]/2) rounds to the nearest integer. Round([Qty]/2) appears to work only because your [Qty] in an integer.