ALTER COLUMN

[rstitzel]

I have an Access Module that imports a text file and then changes the data types of several columns. I want to change one of the columns to single fixed with 1 decimal place.

I have the following code in my module:

DoCmd.RunSQL ("alter table tbl_loadouts_worktable alter [Rt Code] single")

I'm just not sure how to set it to fixed with the one decimal place.

Thanks in advance for any and all help.

 

[RickSpr]

Floating point variables (Single and Double types) do not have a fixed number of decimal places. You specify the single decimal place when you display or print it (that is, in a Text Box control's properties, or table or query field properties).

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein