Auto Report and Macros

[Marc]

Hello -

I'm trying to include an auto report in my macro. The data in my query is
constantly changing an a 'regular' report will omit any data not included in
the original. The autoreport will capture all of the current data.

Any ideas how to include an auto report in a macro?

Thanks,

Marc

 

[Steve Schapel]

Marc,

If the Record Source of your report is a table, or (more commonly) a
query, then the data included in the report will automatically be the
current data as at the time the report is printed. There is no need to
take any special steps to make this happen.

If I have misunderstood you here, please post back with some further
details of what you have there, maybe with some examples.

 

[Marc]

Hi Steve -

Yes, the source of the auto report is the most up to date data retrieved by
a query that is in my macro. I need the auto report instead of the regular
report because I do need the most up to date data. For example if I created
a report based on todays data, it would be for Jan, Feb, Mar, Apr. Next
month when I run the macro (running the query and report) I do not have May
as a field and it would not be included. If I were to build an auto report
the current data would be included and I would see May.

I hope I have explained myself so you can give me your thoughts.

Marc