Passing criteria to queries from forms

N

Neil Beddell

I am putting together a database to record telephone surveys for a number of
companies within a parent group. Each survey is allocated to the specific
group company to which it belongs. I have created a report based on criteria
(dates and group company at the moment) which is passed from a form to the
query underlying the report - I can therefore generate reports on any date
range and on any single group company. However, I need to be able to generate
a report on all group companies combined but am not sure how to reflect this
in the query crieteria. My idea so far is to set the 'group company' control
in the selection form to Null and in some way have the query pull out all the
records in the given date range regardless of group company (whilst also
keeping the option of being able to select a group company at need). Any code
or SQL appreciated. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top