Changing the Data Type of a Calculated field

Anthrax

New member
Local time
Today, 07:25
Joined
Jun 25, 2013
Messages
7
I am trying to change the data type of a field in a table from calculated to something else. It gives me the error "this data type cannot be changed once the field has been saved"

Is there any work around to this?

If not its not the end of the world.
 
You will have to add the field you want with the data type you want, run an update query to move the data over from the other field and then delete the old one.

And I highly suggest that unless you are using a Web database or have a very specific need to save calculated values it is not good practice to store calculated values.
 
Thanks, solved it.

The reason I'm wanting to change the data type is because I want to stay away from calculated.
 

Users who are viewing this thread

Back
Top Bottom