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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Embed the same Excel multiple times 0
Finding the right style field in VBA 0
Copy previous record into form field 0
VBA word change keys 0
Finding the proper style field and the numbered paragraph value within the style 0

Top