I need to create a query that searches 2 out of the 5 fields. I have set the criteria to a Like "Enter Key word" but it only searches that one field. I want it to search the Title field and the Keyword field. Any suggestions?
If I understand what you are trying to do, all you need to do is move both of the criteria statements onto the same row and they will act as AND criteria instead of the OR criteria that you have now.
If you want to search both fields for the same criteria, do you want to return records that match in either field or only return records that match in both fields? What you have right now will return records where the criteria matches in either field.
If the criteria is the same for both of the fields consider running the query from a form so the criteria only has to be entered one time.
If I understand you, I think you want to search that table to find records where the title field is like the first parameter or the key word field is like the second parameter. If you haven't tried it yet change the AND to an OR and see what happens. If this doesn't work --
Does access prompt for both parameters when you run the query? Maybe you could post some sample results of what you're getting and what you want instead.