Query same info from multiple fields

[SuePee]

Hi and thanks for all your help prior to this.

Here is my dilemma.
-I have an item that has (9)components placed in it.
-Each item has a serial no.
-Each of these components comes from a particular lot.
-All of the components are the same type.
-(4) of these items go into the final product.
-Final product has a serial no.

I need to make a query that will seek out which final product serial numbers contain which component lot number.

In other words, if we get notification of a defective lot number, we need to know which final products contain that component.

I tried using an OR query, where the item in question is in lot #1 or Lot #2, ... or Lot #9 but it returns an empty output.

I am using this statement in the query (Like [Enter Lot No])
on each field.
Where did I go wrong?

 

[SuePee]

Sorry,
I was entering the wrong data into my own query! Must have had a brain f__t.

But... when I enter the Like [Enter Lot No]How can I get the lot no to appear in the output. I added a field called Lot no, but I have to enter it into the query twice to get any output.

Again sorry for the stupidity, but it is Monday and I guess I need to be retrained.

Sue