Keyword Search Multiple Fields 1

[Heather13]

Although I have no schooling in programming, I've found it necessary to have to modify a database, and I've gotten myself into a bit of a jam.
How would one go about searching multiple fields (14) for an entry?
I figured out how to search one field at a time using:


Like "*" & [Enter Lot Number to Search By] & "*"


as the criteria in the design view of the query, but I am not sure where to go from here...
any consideration you extend my way would be greatly appreciated.

 

[lynchg]

If you are enter the entire Lot Number you don't need the Like operator and the asterisks, they will only slow down the query.

You can put [Enter Lot Number to Search By] in the criteria field of the 14 fields you are searching on dropping down to the next row of criteria fileds each time like this:

[Enter Lot Number to Search By]
[Enter Lot Number to Search By]

But this would be horrendously slow, you would be better of breaking it up into 7 queries of 2 each or 5 queries of 3,3,3,3 and 2.

It would also be important to have these fields that are being searched indexed, that will help performance tremendously, especially if your table has hundreds of thousands of records or more.

HTH