Search Data

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

Guest

I have a table ' inforr' with column 'jobtitle' and this table have data like
welder,cook and other job titles. I want to make a query where I put a job
title and data should be displaced
 
Go to Queries and then select new. Click on Design view. Once in design
view, double click on the table that you want to run the query on, and then
click okay. Move all the column headings you want displayed in the query
down to the design grid. In the "job title" column, click on the Criteria
field. Then type [Enter job title]. Save the query and then run. This
should work. You can also type: Like [Enter job title] & *.* in the criteria
field. This way you will not have to type the whole job title.
 
Back
Top