Forum Discussion
Solved
SQL or Access query code for filtering the data
Can anyone help me, please. I need immediate help with SQL or Access query codes to show the values in my resultant table below. Thank you in advance. For an example: I have table1 ID Ty...
Nkhatiwada You could use this query:
SELECT *
FROM Material
WHERE Type <> 'EFCL' OR (Type = 'EFCL' AND Material NOT IN('STL', 'STV', 'LED'))I took "Material" as table name, you can replace it with your table name.
Best wishes,
Tieme
I want to hide only STL, STV or LED materials that are EFCL types.
Nkhatiwada You could use this query:
SELECT *
FROM Material
WHERE Type <> 'EFCL' OR (Type = 'EFCL' AND Material NOT IN('STL', 'STV', 'LED'))
I took "Material" as table name, you can replace it with your table name.
Best wishes,
Tieme
Thank you Woldman
This worked! I appreciate your help !