quotient for query

  • Thread starter Thread starter chase
  • Start date Start date
C

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.
 
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
 
Back
Top