SQL Action Query

[wizcow2]

Can I change the type of field in a table with an action query?

Example:
The field 'cost' is a long integer number
and I want to change it to currency.

I tried this but it didn't work.

"ALTER TABLE InvoiceSub SET [cost] MONEY;"

Thanks
Tom

Access 9.0
Win 2k

 

[dgm]

Is that just an example? Because Currency is a format, not a data type...

I've nver used the Alter Table statement, but i think it can only add an delete columns?

The ALTER TABLE statement is used to add or drop columns in an existing table.

ALTER TABLE table_name 
ADD column_name datatype
ALTER TABLE table_name 
DROP COLUMN column_name

 

[pbaldy]

Not sure of the answer, since I don't modify tables in code (so far), but wanted to clarify that currency is a data type in A2k & A2k2.

 

[dgm]

Oh so it is...

Sorry i was thinking of the types for the number data type...

Have a look at this page, it might be what your after:
http://support.microsoft.com/?kbid=210304