Report with Multiple Query

[mfaisal.ce]

Hello Friends,

I need to make a report based on 2 or more queries/Forms/Tables......

First Page of report will show First Query till all records will end. then, next page will start Second query.......

Kindly guide...

 

[theDBguy]

Hi. Maybe use an unbound report with a subreport for each data source. Just a thought...

 

[mfaisal.ce]

Actually,

I have 3 Tables
1.Sales (Master Table)
2.Sales_detail
3.Sales_ Return

what i need is to get whole data of Master Sales Record from Child Tables on Single Report without repeating records.....

kindly guide....