MODIFY A NUMERIC FIELD TO DECIMAL

[vellons]

hi all,

I want to do the following statement "ALTER TABLE TT ALTER COLUMN CC
DECIMAL (18,2)" but doesn´t work. I´ve tried it on differents ways
but keep not working.

I don´t know if I can do it with Ms Access.
Hope that someone may help me.

Juan

[Lyle Fairfield]

"vellons" <ve************@hotmail.com> wrote in
news:11**********************@g47g2000cwa.googlegr oups.com:

hi all,

I want to do the following statement "ALTER TABLE TT ALTER COLUMN CC
DECIMAL (18,2)" but doesn´t work. I´ve tried it on differents ways
but keep not working.

I don´t know if I can do it with Ms Access.
Hope that someone may help me.

Juan

Assuming Version 2000 or greater:

CurrentProject.Connection.Execute _
"ALTER TABLE TT ALTER COLUMN CC DECIMAL(18,2)"

Typically DAO can't do JET 4.0 SQL Innovations but one can use OLEDB
through ADO to effect them.

This is because DAO is the natural, tightly-integrated technology for
Access/JET, faster and better in almost every way. HUH?

--
Lyle Fairfield

[vellons]

Lyle Fairfield ha escrito:

"vellons" <ve************@hotmail.com> wrote in
news:11**********************@g47g2000cwa.googlegr oups.com:

hi all,

I want to do the following statement "ALTER TABLE TT ALTER COLUMN CC
DECIMAL (18,2)" but doesn´t work. I´ve tried it on differents ways
but keep not working.

I don´t know if I can do it with Ms Access.
Hope that someone may help me.

Juan

Assuming Version 2000 or greater:

CurrentProject.Connection.Execute _
"ALTER TABLE TT ALTER COLUMN CC DECIMAL(18,2)"

Typically DAO can't do JET 4.0 SQL Innovations but one can use OLEDB
through ADO to effect them.

This is because DAO is the natural, tightly-integrated technology for
Access/JET, faster and better in almost every way. HUH?

--
Lyle Fairfield

Hi Lyle,
Thanks for your response,

By the way, I could know how to convert to decimal by a query what
create a new table using formatnumber ([field];2), but I don´t know
how to convert exactly this data_type (text) to numeric keeping 2
decimals and without rounding.

thanks a lot.
sorry about my english, i am from spain.

[Lyle Fairfield]

vellons wrote:

sorry about my english, i am from spain.

I'm sorry too; I had guessed USA.