Hello,
I am quite new to Access and I need some help, I can no longer manage with the books I have!
I have built a database with one Main table linked with many other tables and querries mainly by the field "ClientName".
Now I have a problem with the reports:
When I did the form, I did one main form with lots of sub-forms.
I initally tried to do the same for my report: One report with many sub reports, but it seems I couldn't do it because I was limited in size.
I have therefore started to do individual reports, which I was thinking of linking with a Macro later... and this is where I am now stuck:
I also tried launching one report filtered on the current "ClientName" in the form... but I am even having trouble with that...
Should I have a filter in a Macro or on each report (considering I want to have one report to print in the end)?
I am not sure my case is very clear but I hope you can help!
frederique.
I am quite new to Access and I need some help, I can no longer manage with the books I have!
I have built a database with one Main table linked with many other tables and querries mainly by the field "ClientName".
Now I have a problem with the reports:
When I did the form, I did one main form with lots of sub-forms.
I initally tried to do the same for my report: One report with many sub reports, but it seems I couldn't do it because I was limited in size.
I have therefore started to do individual reports, which I was thinking of linking with a Macro later... and this is where I am now stuck:
I also tried launching one report filtered on the current "ClientName" in the form... but I am even having trouble with that...
Should I have a filter in a Macro or on each report (considering I want to have one report to print in the end)?
I am not sure my case is very clear but I hope you can help!
frederique.
