Unanswered: Query not Working as Planned (Access 2007)
I am trying to write a query that finds records in a table if StockType = "component" and part_name = "attenuator" or part_name = "oscillator" or part_name = .... (there are a few more part_names).
I tried using the query designer to do this. The result gave me the correct part names but the StockType was both "component" and "working" (these are the only two stock types). Obviously the WHERE clause was incorrect. I tried to modify it in the SQL view, but I had no luck. If I stick to just one part_name, I get only component stock, but as soon as I add another part name I get both working and component stock records for that part_name.
There are duplicate part names in the table, but each part has a unique part number.