Query Search Criteria for Multiple Columns!! 1

[hathman23]

Hello there, I am very new to Access but hopefully you all can help me out. I have a pretty simple database to enter information from an application form. In the application form the person can select three different job positions they are interested in. I have put three fields into the table each one representing one of the options. I would like to have my query search for a job that the user inputs (just once) and it searches all three columns of data for fields that match that job title in any of the three job choices. What do you all think. Any help will be appreciated, especially something sorta quickly too.

 

[substitute]

Create a new query.

Add the table with the applications.

Select the fields you want, including the three job fields

Enter the text [Enter Job] (including the square brackets) in the first criteria row under the first job field.

Enter the same text in the second criteria row under the second job field

Enter the same text in the third criteria row under the third job field

Run the query

When you get the "Enter Job" prompt enter the job you are interested in

The query will return all records with that job in any of the three fields

When you enter a parameter in a query like that the user is only prompted once per parameter, even though it appears three times.

Good luck