Rounding up Values of a calculated field

[arobbo]

Anyone got any ideas of how i could round up the values of a calculated field in a query. Basically i pull some fields out of an external database do a calculation on them and want the outputted figure to be in pounds only and not pounds and pence or 1392.348835583

Can anyone help?

 

[PHV]

Have a look at the Round function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886