Access Query Data Type

[tmcrouse]

I have a table that has multiple number rows and I can go in and change the datatype on each row but wanted to do it faster than selecting each one and then doing the drop down and then changing the general to double from long integer. I tried selecting all at once but it makes you do it one at a time. I am sure there is an update query I could just run to change the datatype but not sure how to construct that.

update finalacute.rec1 ???????? I am not sure I can select all data types that are a number in one small query but would love to. I have 20 number data types and 2 text. I only want to change the number ones from long integer to double.

[JoeM]

Update Queries only update data, not field data types.

If you want to do that automatically, you will need to use SQL and/or VBA. Here is a link on how to do that: http://www.eraserve.com/tutorials/MS...ange_Field.asp