My sql right now is
SELECT ariInfo.[Part Qualifier], ariInfo.[Part Number], ariInfo.Description, ariInfo.[List Price], ariInfo.Stock, ariInfo.[Supercession or Alternative Part Number], ariInfo.[Part Weight], ariInfo.[Price 1], [Price 1]*0.95 AS [Price 2], [Price 1]*0.9 AS [Price 3], [Price 1]*0.85 AS [Price 4], [Price 1]*0.8 AS [Price 5], ariInfo.[Price 6], ariInfo.[Price 7], ariInfo.[Price 8], ariInfo.[Price 9], ariInfo.[Price 10], ariInfo.[Box Height], ariInfo.[Box Width], ariInfo.[Box Length], ariInfo.[Handling Type], ariInfo.[Handling Value]
FROM ariInfo
WHERE (((ariInfo.[Part Qualifier]) In ('SIL','TH')));
I need to ad something like
AND (Not (ariInfo.[Part Number])=('1') so that this query excludes certain part numbers. If i try to add more than 1 number (ex ('1','2') I get an error. I have about 160 part numbers I need to exclude. How can I do this?
2007-08-01
08:37:19
·
4 answers
·
asked by
luvv2rock
3