Main report with two "sub forms" problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form that logs the main part of a Risk Assessment. I then
have two sub forms linked to each main part of the risk assessment - Hazards
and Actions. These two sub forms have one-to-many relationships with the
main Risk Assessment. How can i best represent this data in a report? I
have tried creating a normal type of query but it does not return the correct
data.

Your help would be greatly appreciated!
 
Stephen Jame Pattenden <Stephen Jame
I have created a form that logs the main part of a Risk Assessment. I then
have two sub forms linked to each main part of the risk assessment - Hazards
and Actions. These two sub forms have one-to-many relationships with the
main Risk Assessment. How can i best represent this data in a report? I
have tried creating a normal type of query but it does not return the correct
data.
Click to expand...


Use subreports in a very similar way to your subform.
 

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

Access Sub form opens before the main form in MS Access 0
Filtering subreports on main report 0
Date Format In A Report 2
how would i create a main report with two different tables/forms within it?? 2
Archiving and copying records 2
Sub-Report Problem 5
Sum of sub-form/sub-report 10
Filter Sub Report 3

Back
Top