Formatting Reports in Access 2007

[bryanCalabro]

Hello all,



I have three tables, project, payments, and change orders. I want to format a report so that it prints out the project information first, followed by a section for all of its payments, followed by a section for all of its change orders, then repeat this for each project. Is there any way of doing this? Also let me know if I did not explain this clearly.

Thanks all

[June7]

Options:

1. query that includes all relevant tables/queries as RecordSource then use report Grouping & Sorting - however, don't this will be suitable with your datasets

2. report/subreports arrangement