Combine results of 2 or more queries into one report

[N_NAGESH]

Hi,

I have two to three queries which gives values of a de-coded engineering component and material.

The code syntax is <size/Component Code / Material Code>. I have created two tables which gives descrition for different Component codes and Material codes.

I have also created queries based on these tables which lists out the description of component code and material code. The user inputs the component code and material code in a form and the query is linked to the field in the form.

Since these two tables do not have any field in common, I am not able to combine these fields in a single query.

I want to generate a report combiming these two queries....
Can anyone help me in this regard

 

[boblarson]

One word - SUBREPORTS

 

[CraigDolphin]

And the long-winded version:

One report containing two subreports.
-One Subreport bound to one query.
-Another subreport bound to the other query.

 

[Stigmundfreud]

I use subreports but....

I run two queries, one to record a rule that is mapped and one to record rules that are not mapped. I'd like to combine the output so the rules are all in one report and those that have no mapping appear highlighted...