Reports from multiple queries that are not linked??

[Jackfam58]

I have a feeling the answer is no but can you create a report from multiple queries that are not linked by a common field As an example
query1: employee_name,employee_id


query2: firm_id,firm_name

The idea is to select multiple employee_id and multiple firm_names or id in a listbox and then create a report with just the values selected.

I am taking this over for a friend. I have a feeling he will need to find a way to link those tables but thought I would ask if there is anything program wise (ie macro or vba) to link tables to produce a report even though they apparently have no relations

[pbaldy]

How about a report with a subreport, or two subreports in an unbound report?

[RayMilhon]

Assuming I'm reading this correctly what you're looking for is a Query that lists elements of Table A According to a selection in Listbox A and elements of Table B According to Selections in Listbox B. If that is the case then essentially this is what you want. However, You will have to research to get the syntax right.

Select A.element1,a.element2,b.element1,b.element2 from TableA as A, TableB as B Where A.element1 In (listboxA.selecteditems) and B.element1 in (ListBoxB.selecteditems)