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