Chaining Queries Together with a Macro

C

Casino Analyst

I tried Macro - TransferDatabase to run a select query with parameters that
ask me for start date and end date and returns dollar amounts for each
existing date in the range and saves the result table as named in the
Destination Field. Can I enter a parameter in Destination to prompt me for a
name for the table? Next query sums the dollar amounts for the date range
and final query exports result to Excel. I want the macro to repeat the
steps as I enter Jan08, Feb08, Mar08, etc.
 

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

Setting column width in a table with a macro is not working 0
Change a great number of words in word files, with a macro as short as possible. 5
macros with a macro 1
Macro Condition that references result of a query? 6
Array with many cells from a row but not in order or together 11
Parameterized queries in macro 1
Subtotaling Quarters (and Years) from Months 4
Macro with make table 1

Top