Multiple Queries into one report.

[Ray67]

Hello

I need help with reports. I have about 5 queries with data. I would like to combine all 5 queries into one report based on 3 parameter. The parameters are Provider name, Date from and Date To. Can this be done and how????



Thank you,

[RayMilhon]

Can it be done? Yes How depends on the structure of your queries. but I would think that a main report with 4 sub reports is probably the way you want to go.

[Ray67]

All queries will have provider name date from and date to. How would i be able to do this???


Thank you

[RayMilhon]

Bear in mind that I have no clue as to what data elements are in your query so this just a ball park suggestion (A rather large ballpark by the way) But you would create a Report for Each Query. One of those reports would be your main report. Then I am assuming here that the table holding your provider name also has a field used for the primary Key make sure that is included in all queries. Put all of the sub reports in the group footer for provider name and link them using the primary key for Provider the rest depends on your data so I can't help you there.