i want to produce a summary report from data in 15 individual reports each
month. The reports are saved under the same file name each month but in a
newly named folder - I have set up my report for this month - I want to be
able to have a system whereby all i do is enter a new folder name somewhere
in the master report and it automatically knows to look for the same data but
in a new month - help!

Hi
Ron de Bruin has written lots of code to deal with different types of data
aggregation like this.
Take a look at
http://www.rondebruin.nl/copy3.htm

--
Regards
Roger Govier

"suesolotel" wrote in message
...
i want to produce a summary report from data in 15 individual reports each
month. The reports are saved under the same file name each month but in a
newly named folder - I have set up my report for this month - I want to be
able to have a system whereby all i do is enter a new folder name
somewhere
in the master report and it automatically knows to look for the same data
but
in a new month - help!

Thanks Roger
I'll try this out

"Roger Govier" wrote:

Hi
Ron de Bruin has written lots of code to deal with different types of data
aggregation like this.
Take a look at
http://www.rondebruin.nl/copy3.htm

--
Regards
Roger Govier

"suesolotel" wrote in message
...
i want to produce a summary report from data in 15 individual reports each
month. The reports are saved under the same file name each month but in a
newly named folder - I have set up my report for this month - I want to be
able to have a system whereby all i do is enter a new folder name
somewhere
in the master report and it automatically knows to look for the same data
but
in a new month - help!