Need to find records in special circumstances

[Dave14867]

Hello all,

I ran into an issue the other day and I had thought I had a solution over the weekend but as it turns out, it doesn't seem to work.

I have a form with a subform that the user has to enter lot numbers into, these get written to a table. Most of the time, any row will have only 1 lot number associated with it, however, occasionally, there may be 2 lot numbers associated with a single row, the lot numbers separated by a comma.

Example 1: Part 12345, Lot 456789
Example 2: Part 12345, Lot 456789, 567890



The issue I have is that I have a query that looks through the table the data is being written to to find info about the lot number, like what part was it used in, how many pieces, how many different assemblies, etc. This all works fine unless there is more than 1 lot used as in Example 2. I have tried to use a Wildcard (*) but it doesn't return the instances where more than 1 lot number is used.

In the "Criteria" for the query, I have [Enter Lot Number] so the user has to enter the info for the lot number in question.

Any thoughts?

Dave

[JoeM]

Try this criteria:

Like "*" & [Enter Lot Numer] & "*"

[Dave14867]

JoeM,

That worked like a Charm. Thank you. I never thought about putting the "Like" in there like you did. Thanks for educating me a bit more today.

Dave

[JoeM]

You are welcome.
Glad I was able to help!