Want to find any record containing any part of a string

[Dave14867]

I have a query and want it to show me any records that contain any part of a string. I have this in the Criteria - Like "*" & [Enter Lot Number] & "*". It only shows me 1 record and I know there are 2. The first record contains only that string of numbers, the second contains another string followed by a comma and space then the Lot Number I entered.



My Criteria is only showing me a record where the Lot Number is by itself.

Does Show 802407

Doesn't show 802339, 802407

How do I need to modify the Criteria to show the Lot Number string no matter if it the first or second Lot Number in the field? (ie. 802407, 802339 or 802339, 802407)

Thanks

Dave

[Welshgasman]

Use the Like operator with * on either side of your search string, which you say you have already done?, so I am puzzled as to why it would not work?

Off to test myself.

Edit: OK, I'm back, works for me?

[Dave14867]

I rebuilt the query and it is working now. I have had issues with some of my queries not functioning as they used to lately. I thought this was previously working but when I tried it yesterday, it didn't show everything and I thought maybe I had the criteria wrong. Sorry for the confusion.

Thanks

Dave