Desperate!!! Subreport Help.

A

Ayo

I have never used subreports before and I am having a very hard time here.
What I need to do is this. I have 5 tables and they all have Project Number
and Task Number in them. The Tables are:
SITE LIST
Inscope Table
Outofscope Table
Actuals
Commits
I want to select Project Name,Project Number, Task Number, Site ID as the
header of the report and also the data for the main form. Then I want to
create 4 subreports using the other tables but I want them to only display
their selection based on the Project Number and Task Number in the main form
(i.e. the SITE LIST table). How do I do this. Any reference will also be
appreciated. I am really stuck.
Thanks
 
D

Duane Hookom

Subreports are very similar to subforms. You can use the Link Master/Child
properties of the subreport control (just like subforms) to filter the
subreport records to specific values in the main report.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with report & subreport 4
Help with Summary Report 3
Access How to prevent subReport from breaking across pages? 1
limitation subreport 8
Using Subreports to create a Main Report 7
Furstrated!!! Help. 3
Subreport null data 2
Can't understand the error message 6

Top