Hi
I am modifying an existing report. basically, i have data for multiple dates for multiple facilities in temporary tables. I then ouput a report to word/excel files. I would like to add a filter to a report. I am using the docmd.output to export the reports. the following is what i have been thinking would work, but i am looking for ideas.
1. open the report in design view - docmd.openreport, modify the recordsource, and save it. first of all i am not sure how to do it, and also i think i might get a message that you can modify a report when another user is logged in (even though i don't anticipate having other users use this database).
2. some how use the open event and have a global variable to set criteria. not sure how to this, and i am not sure it will work.
your help is much appreciated it.
thanks,
sam
I am modifying an existing report. basically, i have data for multiple dates for multiple facilities in temporary tables. I then ouput a report to word/excel files. I would like to add a filter to a report. I am using the docmd.output to export the reports. the following is what i have been thinking would work, but i am looking for ideas.
1. open the report in design view - docmd.openreport, modify the recordsource, and save it. first of all i am not sure how to do it, and also i think i might get a message that you can modify a report when another user is logged in (even though i don't anticipate having other users use this database).
2. some how use the open event and have a global variable to set criteria. not sure how to this, and i am not sure it will work.
your help is much appreciated it.
thanks,
sam
