How can I change a field name's data type automatically in query?

H

hard head

Part of the table I create each month, from a sql database, is based on two
"numeric" fields where I calculate the difference in my query. The data type
of this field then has to be changed to "currency". Can a macro be created
to change the data type of the field in the table?
 
Top