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 ex****ts result to Excel. I want the macro to repeat the
steps as I enter Jan08, Feb08, Mar08, etc.
--
Casino Analyst
