How do I combine query results?

[neha]

I have created a database with a Query by Form where the form passes filter parameters to the query based on user input.

What I want to do is this-
1.The user feeds in search criteria via the form interface and runs the query to get records meeting this search criteria.
2. User selects one (or several) of the records given by the query and stores them in a temporary location (A)
3. User runs a second search with new search criteria to get a new set of results.
4. User stores these new results in the same temporary location (A)
5. User runs the same query multiple times each time with different values fed to the search parameters to obtain filtered records given to A.
6. Push results stored at A into a report.
7. Delete all data at A so that steps 1-6 can be repeated



It would be nice to also have the results in a place where they can be exported to an excel spreadsheet.

Any thoughts on how I can do this?

[alansidman]

Why can't you run one query with multiple criteria to get one exportable recordset?

[neha]

I'm sorry I should have made myself clearer. My query's search criteria are fixed. This database is used to select products for procurement out of a vast database of medical devices.

The person runs a search of the entire database based on device type, technical specifications, departments in which it will be used, etc. The person feeds in the filters such as:

Look for devices with,
Type: X-ray Machine
Department:Radiology
Manufacturer: Philips

The query returns a list of all the X-ray machines by Philips. He/she selects the machine they want.
Next the person looks for another piece of equipment needed in the radiology dept, say an ultrasound machine. So he/she runs another search,
Type:Ultrasound, Dept: Radiology, Manufacturer: Any

But the selected x-ray machine and the selected ultrasound machine need to be sent to the same common place. The peron has to do this more than 10 times to get a comprehensive list of all the equipment needed in a radiology department.

Then this list has to be exported to an excel sheet.

How do I do this?