Passing criteria to queries from forms

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.
--
Neil Beddell

Meant to say, am on Access 2000!
--
Neil Beddell


"Neil Beddell" wrote:

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.
--
Neil Beddell

Problem solved!
--
Neil Beddell


"Neil Beddell" wrote:

Meant to say, am on Access 2000!
--
Neil Beddell


"Neil Beddell" wrote:

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.
--
Neil Beddell