VAT 20% decimal place help

[KenshiroUK]

Hi there, I have created a simple VAT query that calculates tax of 20%. However it displays more numbers than it should do, I wish to set a cut off limit for it.

I have this so far VAT: Sum([invoice table]![Total Price]*17.5/100) which would display this: 49.392. I would like it to display 49.39 instead. same for 17.61025 which should be 17.61.

 

[JHB]

Try round:
Round(Sum([invoice table]![Total Price]*17.5/100) ,2)

 

[KenshiroUK]

Worked like a charm, thanks!