Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combine multiple queries to create a Report

Status
Not open for further replies.

kastaman

IS-IT--Management
Sep 24, 2001
181
0
0
CA
Hi there,

I have a few queries that have parameters that are client specific [formNo] and {jobName].

I'd like to create a report that would present the info from the queries.

Do you have any suggestions.


Thanks in advance,

Kastaman
 
Your best to do a report for each one, then produce a main report containing all the reports.

This way you are not limited to the number of rows in one of the sub reports, you can set it to auto grow each sub report.

If you have multiple report using the same parameters, this does not mater, once you have got the information from a form, or typed it in, then you do not have to do it again.

Hope this makes sense.
 
M8KWR,

How would I combine the reports? Would this be like a subreport scenario?

Thanks in advance,

Kastaman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top