Variable in Criteria

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

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
 
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
 
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....
 
Back
Top