Hi all - am trying to create a query across multiple tables and have hit a brick wall. I want to give the user the option to generate any one of several outcomes from the same query but don't know if it is possible. So the user has the option to answer either 1 or several questions to generate a report - e.g. which colour, which type, which location... to generate their bespoke report. Is that possible from only 1 query?

This is one technique:

http://www.mvps.org/access/queries/qry0001.htm