Other Category affected by changing a condition in a query?

[ice]

Hi I have a condition in one of my field named "Material type" and the condition is to show only those that are called "zext". This is in QUERIES. But now we need to add the name called "zerv" So I just add that name in condition using (or). I tried to run it, but the report still shows those that are "zext".



I'm not sure if there are things that must be changed as well like in tables, forms, etc.

Kindly help! thanks in advance!

[JoeM]

Switch your query to SQL View, and copy and paste the code here so we can see how you have written it.

[ice]

Switch your query to SQL View, and copy and paste the code here so we can see how you have written it.

Hi


Hi, thanks a lot for your reply. Here's the code for one of many queries that i changed. hope it would help.

SELECT ZQR.[Material Number], ZQR.Plant, ZQR.[Sales Org#], ZQR.[Purchasing Org#], ZQR.[Distr# Channel], ZQR.[Base Unit], ZQR.GenItemCatGroup, ZQR.[Material Type], ZQR.[Material Group], ZQR.[X-plant status], ZQR.[D-Ch#Statu], ZQR.[Deliver#plant], ZQR.[Gross Weight], ZQR.[Net Weight], ZQR.[Weight unit], ZQR.Volume, ZQR.[Tariff No#], ZQR.[Exp# ctrl# cl - EU], ZQR.[Exp# ctrl# cl - EUS], ZQR.[SC Code], ZQR.[Item cat#group], ZQR.[P-Code], ZQR.[Ctry of origin], ZQR.[Purch# Group], ZQR.[Valua#price], ZQR.[Company Currency], ZQR.[Tax classific#], ZQR.[Valuation Class]
FROM ZQR
WHERE (((ZQR.[Material Type])="zext") AND ((ZQR.[D-Ch#Statu])="04")) OR (((ZQR.[Material Type])="zerv") AND ((ZQR.[D-Ch#Statu])=""));

[ice]

Hi JoeM, never used the sql view, it helps a lot reading it. I think I can solve it now. I will try later, with this new code.

SELECT ZQR.[Material Number], ZQR.Plant, ZQR.[Sales Org#], ZQR.[Purchasing Org#], ZQR.[Distr# Channel], ZQR.[Base Unit], ZQR.GenItemCatGroup, ZQR.[Material Type], ZQR.[Material Group], ZQR.[X-plant status], ZQR.[D-Ch#Statu], ZQR.[Deliver#plant], ZQR.[Gross Weight], ZQR.[Net Weight], ZQR.[Weight unit], ZQR.Volume, ZQR.[Tariff No#], ZQR.[Exp# ctrl# cl - EU], ZQR.[Exp# ctrl# cl - EUS], ZQR.[SC Code], ZQR.[Item cat#group], ZQR.[P-Code], ZQR.[Ctry of origin], ZQR.[Purch# Group], ZQR.[Valua#price], ZQR.[Company Currency], ZQR.[Tax classific#], ZQR.[Valuation Class]
FROM ZQR
WHERE (((ZQR.[Material Type])="zext") AND ((ZQR.[D-Ch#Statu])="04")) OR (((ZQR.[Material Type])="zerv") AND ((ZQR.[D-Ch#Statu])="04")) OR (((ZQR.[D-Ch#Statu])=""));

[ice]

now it worked! thanks a lot for introducing the SQL view

[JoeM]

Great, glad to hear you got it sorted out!