How do I round up a function like this: =Sum([Quantity])
T Tom Wickerath Oct 22, 2005 #2 Have you tried using the Round function? =Round(Sum([Quantity]),2) This should round to two decimal places with what is commonly known as "Banker's Rounding". Google this term if you want to learn more about it. Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ : How do I round up a function like this: =Sum([Quantity])
Have you tried using the Round function? =Round(Sum([Quantity]),2) This should round to two decimal places with what is commonly known as "Banker's Rounding". Google this term if you want to learn more about it. Tom http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ : How do I round up a function like this: =Sum([Quantity])
