I have a question

[trackmedic]

My report for my project is pulling info from a query that queries three tables.

For simplicitys sake, there is a main table a good table and a bad table. I want my report to reflect the info from the main table as the header and the info from the good and bad tables in the detail section. Is there a way to have 2 detail sections in a report?

As I have it now I have the following happening

main info

good
bad
good
bad
good
bad

I would like

Main info

good
good
good

bad
bad
bad

basically sorting and keeping the info together.

thanks in advance!

 

[coyote]

SubReports

Try and make subreports.
The process is the same as that of making subforms.
have the Main Report with the header as the parent and the other two reports as the children.
NB You will have to be careful with the linking.Check to make sure that all the links are correct or you will get an error.
Thanks