Data Type Changes

[CJ]

Hi all,

I'm changing the data types, from text to number, in my
table to build an expression in my query. However, I get
the following two messages: 1)"MS can't change the data
type". and 2) "errors were encountered during the save
operation - data types wre not changed". I'm used double
and long integer for field size. Is there any quick
fix? Any help would be great!

Thanks in advance!

 

[Ken Snell]

Sounds as if you have one or more nonnumeric values in the table's field.
Check the records' data to see if this is the problem.

 

[CJ]

Just checked - the field consists of all numeric values.

 

[John Vinson]

Hi all,

I'm changing the data types, from text to number, in my
table to build an expression in my query. However, I get
the following two messages: 1)"MS can't change the data
type". and 2) "errors were encountered during the save
operation - data types wre not changed". I'm used double
and long integer for field size. Is there any quick
fix? Any help would be great!

Thanks in advance!

I've found all sorts of problems in changing table field datatypes;
I'd suggest creating a new table with the desired datatypes, and
running an Append query to migrate the data from the old table.