Changing data type with sql

[anderson7]

Can anyone help me with the sql for changing a datatype to decimal, precision 9, scale 2?

I'm pretty new to sql and seem to be banging my head against a brick wall at the moment!

Many thanks.

 

[namliam]

you cannot, access doesnt have that datatype, that is an oracle type (probably) which can be "replaced" by a double.... I think... maybe even a long... but I am not sure.

 

[anderson7]

Ah, okay. Thanks!

So how would I set up the precision and scale in integer using sql? Everything I've tried comes back with a syntax error...

 

[The_Doc_Man]

You don't do it at all in SQL.

In Access, the data type of a stored item is whatever native type it happens to be.

You specify the precision and scaling in something that will have to use that number for output to any human-readable medium. E.g. forms or reports. Look at the properties of form/report text-boxes to see how to set scaling and format.