changing data type in macro

S

sgtusmc_jrd

I have designed a macro to run a query from two linked
tables. My problem is that during the building of the
table there are two field from the old tables that are
text and I need to change them to numbers. Is there a way
to do this within the macro so that I can set it up as an
excecutable. Thanks for your help
 

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

Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA word change keys 0
Converting URLs in comments to Markdown-formatted links 2
Creating a Chart on form from selected data in query. 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Setting language of a selected text in Office apps. 0
Embed the same Excel multiple times 0

Top