If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Passing criteria to queries from forms
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 |
#3
|
|||
|
|||
Passing criteria to queries from forms
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 |
Thread Tools | |
Display Modes | |
|
|