Integer in query column

SAC · Jan 22, 2004

Access 2000

How do I make a number into an integer in a query column? I've checked the
format, but only find fixed and no decilmal setting.

Thanks.

Arvin Meyer · Jan 22, 2004

SAC said:
Access 2000

How do I make a number into an integer in a query column? I've checked the
format, but only find fixed and no decilmal setting.

Typically, you'd use the CInt() function as in:

Expr1: CInt([ColumnName])
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access