Hello,
I am working on a query the contains an order number, part# and Bore dimension. Recently people have been entering too large of bore dimensions which cause a part to be made incorrectly. There are 30 different part numbers that i am checking to see if the bore dimensions are correct for and there are about 50 orders entered each day. I am not exactly sure how to check this... I created a basic query that was:
SELECT [Error Check].[Order*Line Item], [Error Check].[Part#], [Error Check].BoreNum
FROM [Error Check]
WHERE(([Error Check].[Part#] = 073560-000) and ([Error Check].BoreNum >2.93))
I was planning on writing OR for each part number in the where clause but i am getting an error when i attempt it with just one number. If anyone had any suggestions i would appreciate it.
I am working on a query the contains an order number, part# and Bore dimension. Recently people have been entering too large of bore dimensions which cause a part to be made incorrectly. There are 30 different part numbers that i am checking to see if the bore dimensions are correct for and there are about 50 orders entered each day. I am not exactly sure how to check this... I created a basic query that was:
SELECT [Error Check].[Order*Line Item], [Error Check].[Part#], [Error Check].BoreNum
FROM [Error Check]
WHERE(([Error Check].[Part#] = 073560-000) and ([Error Check].BoreNum >2.93))
I was planning on writing OR for each part number in the where clause but i am getting an error when i attempt it with just one number. If anyone had any suggestions i would appreciate it.