Displaying a whole number quotient

  • Thread starter Thread starter Chase
  • Start date Start date
C

Chase

My query is set up as below.

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

My quotient shown in the table is carried out to 12
decimal places. What command do I use to round to the
nearest whole number and where in the query matrix above
do I place the command? Danny Lesandrini gave me three
options. I tried inserting 'CInt (23/9) = 3'
under 'update' and 'criteria'. Neither worked. Maybe I
am not inserting it into the query properly.

Thanks
 
Back
Top