Multiple inputs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a list of offices and tasks that go with each one. I
have a querie that prompts a user to enter an office number to pull up only
that offices tasks. Is there a way I can make the prompt ask for multiple
offices?

Thanks
 
Mike said:
I have a table with a list of offices and tasks that go with each one. I
have a querie that prompts a user to enter an office number to pull up only
that offices tasks. Is there a way I can make the prompt ask for multiple
offices?
Click to expand...


Instead of using a criteria like:
Office = [Enter Office]

Add a calculated column with an expression:

InStr("," & [Enter Office List] & "," , "," & [Office] &
",")

and set the column's criteria to
0
Click to expand...

The office list that the user ensters must be comma
delimited with no spaces before or after the commas.
 
Back
Top