Muliple field criteria based on 1 input

[tpeter]

I changed it to
FROM (select Changes.Part_Number_1 As Prod, [ECN_Number] as Location from Changes
and I get the error of my columns do not match. Assuming becuase there is 2 columns in the start and there are 3 in the union selects?

 

[tpeter]

I think I've got it. checked against it and it seems to be good. Thank you very much for your help.

SELECT *
FROM (select Changes.ECN_Number As Prod, [ECN_Number] as Location from Changes

Union All

select Part_Number_1, [ECN_Number] from Changes

Union All

select Part_Number_2, [ECN_Number] from Changes

Union All

select Part_Number_3, [ECN_Number] from Changes

Union All

select Part_Number_4,[ECN_Number] from Changes

Union All

select Part_Number_5,[ECN_Number] from Changes

Union All

select Part_Number_6,[ECN_Number] from Changes

Union All

select Part_Number_7,[ECN_Number] from Changes

Union All

select Part_Number_8, [ECN_Number] from Changes

Union All

select Part_Number_9, [ECN_Number] from Changes

UNION ALL select Part_Number_10, [ECN_Number] from Changes) AS Q
WHERE Q.Prod = [Enter Part Number];

 

[vbaInet]

Grand! Happy to hear!