I need a bit more information.
Do you want to run the report as the query data changes?
Or, do you want to run the report on a regular schedule?

-Nicole


"knadt" wrote:

I have 2 files one is query data and other is report.the query data changes
periodically.report is made from the query data. how should i write a macro
for this dynamic data.