Data Type Changes

  • Thread starter Thread starter CJ
  • Start date Start date
C

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!
 
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.
 
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!
Click to expand...

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.
 
Back
Top