Rounding Numbers (Access 2000)

Topic

New Reply

Is there an expression I can use to round numbers to the nearest tenth in a query?

Reply | Quote

Replies

Use =Round(Something,1) where Something can be a field name or an expression (if the field name contains spaces, enclose it in square brackets).

Reply | Quote

I get an error message “Undefined function ‘Round’ in expression.” when I run the query. I am dividing Field A /Field B = Field C. Field B has 0 decimals defined, while Field A and Field C have three decimals defined.

Reply | Quote

Here is a KB article that might help. This is another one to check out.

These are for Access 2000, according to the Microsoft Knowledge Base.

HTH,

Tom

Reply | Quote

Apparently this solves my problem. Many thanks.

Reply | Quote