SUM calculation

[KenshiroUK]

Hi all I currently have

=Sum([Extended Price]*1.2-[Extended Price]) however it is showing a price of 9.144, however I want it to just show 9.14. is it something to do with round?

 

[pr2-eugin]

I thought I already gave you some hints with Access Rounding in THIS thread..

Anyway, how about..

=[URL="http://www.techonthenet.com/access/functions/numeric/round.php"]Round[/URL](Sum([Extended Price]*1.2-[Extended Price]), 2)