Integer in Query Column

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

Access 2000

How do I make a query Column an integer. I checked the Format on the column
and there's an option for Fixed, but no decimal setting.

Thanks.
 
See Access Help on how to use the convert to integer
function CInt()
In your query (column) enter the following where Field1 is
the field that you want to convert.

Expr1: CInt([Field1])
 
Back
Top