rounding to 0 decimals

[Guest]

i am using Access 2002. I want a field in a query to give me a number with
no decimals. Currently I get 2 decimal responses. How do I do that?

Thanks in advance! Paul

 

[Octavee Uhl]

Go to the field in the query and click on properties, than choose 0 under
decimal places.

 

[Guest]

Try

Int([FieldName])

Or
Round([FieldName])

Or
Format([FieldName],"#")