Hello
I am in need of help to combine reports in access 2007.
I am trying to create a report from 3 reports - 2 individual reports and 1 report-with a sub-report. All of them have an ID field in common.
Hence I would like to view all the reports together filtered by that ID field (Report to be run from a form).
I have created a blank report and added all 3 reports in the detail section. I would like the ID and Name (the filter condition) to be displayed in the report header. But I am unable to set the filter correctly.
Also, the combined report doesn't show any data in it, where as the individual reports do have some data in them.
I am new to access with very less knowledge on access vba.
Kindly help me to go about with this (Please excuse me on the lengthy description).
I am in need of help to combine reports in access 2007.
I am trying to create a report from 3 reports - 2 individual reports and 1 report-with a sub-report. All of them have an ID field in common.
Hence I would like to view all the reports together filtered by that ID field (Report to be run from a form).
I have created a blank report and added all 3 reports in the detail section. I would like the ID and Name (the filter condition) to be displayed in the report header. But I am unable to set the filter correctly.
Also, the combined report doesn't show any data in it, where as the individual reports do have some data in them.
I am new to access with very less knowledge on access vba.
Kindly help me to go about with this (Please excuse me on the lengthy description).
