Rounding

[bayman]

Is there a function that allows me to round a number in a query and/or report?

Thanks in advance.

 

[Rich]

Search here for rounding, there have been many examples posted

 

[sandhurstUK]

Within the criteria of your query - select properties and then under the General Tab click in the Format field and select Fixed, and then in Decimal Places specify the number of places you require.

The same goes for any field in a report - form - or table.

Hopefully this is what you were looking for.