round and sum

[zzzzzeke]

can you round a sum

SELECT payment_method, SUM (subtotal)
FROM orders
group by payment_method
order by payment_method

 

[ClaireHCM]

Sure you can,

SELECT payment_method, Round(SUM (subtotal),0)
FROM orders
group by payment_method
order by payment_method


SELECT payment_method, Round(SUM (subtotal),-1)
FROM orders
group by payment_method
order by payment_method


SELECT payment_method, Round(SUM (subtotal),1)
FROM orders
group by payment_method
order by payment_method

 

[mikey69]

It' s not quite as simple. The MS Access round function doesn't handle the rounding of 0.5 consistently and you have to use (int(value *100 +0.5)/100) to round to two decimal places. check Helen feddema's site for more detail if you dson't understand this brief explanation.

Access makes all things possible. It even makes them intelligible