title: MS Access alter multiple columns
body: <p>I have an ODBC linked table from JDE/AS400 that I'm bringing into MS Access 2010. The table has four fields with data types of decimal that I need to convert to double data types once I've written them to a temp table. Is there not a way to have four alter table/column statements in one query?</p>
  
  <p>In case anyone is wondering, the data stored in these fields is price and cost, but they are stored in the ODBC table as decimal values of 15 with 0 trailing decimals and I have to divide two by 10,000 and one by 100,000 to get the decimal points in the right position to represent the true price/cost For example, 3558767 in the price field is actually a price of 355.8767 or 355.88 rounded). When I bring the same data into Access and divide by 10000, I get 355.00. I need the correct cents value. The only way I've been able to do this in the past is to write an alter table/alter column query to change the data type to double before performing the division.</p>
  
  <p>Since I have four of these fields, I'd like to alter or modify all four at once. Any ideas?</p>
  
  <p>Any help is appreciated.</p>