quotient for query

[chase]

What is the command in a query to have a quotient rounded
to the nearest whole number in the table? The query that
is set up is:


(column 1) (column 2) (column 3)
Field: A B C
Table: table name table name table name
Update to: [A]/


Need to have the quotient [A]/ to display in the table
as a whole number.

Thanks.

 

[Danny J. Lesandrini]

Here's some testing from the debug window that should help you choose:

? 23/9 = 2.55555555555556
? 23\9 = 2
? CInt(23/9) = 3

The first is regular division, the second is Integer Division, and the third
uses the convert to integer function, which rounds up after .5