Duplication of Data on Reports

[makpk]

Hello
I am working on a report, where I have some parent data (in one table) which I placed in Header. Then I want to show some child data (in two different table or Queries) when I placed it's like that:

Header of Report
Parent Data
-
-
-
-
Page Header
empty
Detail
Record 1 (Query 1)
Record 1 (Query 2)

Record 2 (Query 1)
Record 1 (Query 2) here is the duplication

What I want report display first all record from query 1 and all from query 2 without duplicating. what I like

Detail
Record 1 (Query 1)
Record 2 (Query 1)

Record 1 (Query 2)
Record 2 (Query 2)

Thank you in advance if someone can help..................

[Allan Murphy]

Create two sub reports one with query1 the other with query1. Alternatively, look at using a union query to join the the two queries and use this union query for your report.

[makpk]

Thank you! I think subreport Idea is great................
Thank you again