Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ALTER COLUMN

Status
Not open for further replies.
kashew

kashew

Programmer
Feb 22, 2001
35
US
I'm using Access 2000. I need to change a field to type DOUBLE FIXED with 2 decimal places. ALTER COLUMN DOUBLE works fine, but ALTER COLUMN DOUBLE(Fixed,2) doesn't work. Can someone help me please?
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
2K
combo
combo
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
887
Swi
Swi
teach314
  • Locked
  • Question
Filling a column with 'missing' values 1
Replies
5
Views
239
dhookom
dhookom
uwrijc
  • Locked
  • Question
Using a separate sort column works in query, but doesn't transfer to pivot table or chart view 1
Replies
5
Views
237
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top