I have used client access to record the steps which I used to run my query and I created a macro.I would like to modify the macro to do the following:-
I want the macro to run for 48 times and create the database based on following criteria.
In my select records i have defined the date range for one month(date range 20040620 20040719) I want to modify my created macro to produce me a report for the 2 months 3months 4months ... 48 monhts.
I want the macro to automatically change the 2 months date to (20040720 20040819) and so on.
Your help will be highly appreciated.Thanks
I want the macro to run for 48 times and create the database based on following criteria.
In my select records i have defined the date range for one month(date range 20040620 20040719) I want to modify my created macro to produce me a report for the 2 months 3months 4months ... 48 monhts.
I want the macro to automatically change the 2 months date to (20040720 20040819) and so on.
Your help will be highly appreciated.Thanks