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
|
|||
|
|||
Variable in Criteria
Hello,
I have a query setup with date and 7 locations, so there are 8 columns(fields). In the 7 locations(fields)there can be only one person listed. They can be listed in any one of the 7 locations. I know how to setup the Criteria for "Or" in the rows. What I need to know is there a way to use a Variable in a drop down box or Just a Paramater Box where you can enter just the name once and it will work across the 7 locations? I hope I explained this correctly. TIA Jack |
#2
|
|||
|
|||
Variable in Criteria
to be honest your table structure sounds bad you should have a
different table structure then you could run a cross tab query or something something like location table locationid locationdescription person table personid personname locationpersonlink table locationid personid locationpersonlinkdate if you want a paramater to work accross different columns then you have to enter it accross different columns you cannot use a drop down list unless you build a form to do it for you Regards Kelvan |
#3
|
|||
|
|||
Variable in Criteria
sure. if the name is entered in Form1 NameTextBox
then in the criteria of your query, in all 7 fields - but the same criteria: Forms!Form1.NameTextBox put them all on the same line in each of the 7 fields and it should work fine.... -- NTC "Jack" wrote: Hello, I have a query setup with date and 7 locations, so there are 8 columns(fields). In the 7 locations(fields)there can be only one person listed. They can be listed in any one of the 7 locations. I know how to setup the Criteria for "Or" in the rows. What I need to know is there a way to use a Variable in a drop down box or Just a Paramater Box where you can enter just the name once and it will work across the 7 locations? I hope I explained this correctly. TIA Jack |
Thread Tools | |
Display Modes | |
|
|