Problem with specific query returns

[rebfein]

I've been tasked by my boss to start creating reports for our suppliers re: particular products/

One supplier supplies many products we use, but I need to create a query for only specific ones in one report. However, when I try to do this, I get the specific products, FROM ALL THE SUPPLIERS we buy from!

Here is the initial query for one Product and it produces that result fine:


But when I try to query for specific products, here's what I enter and what I ended up with:


As you can see, it lists the specific parts that begin with IC, QS or QF; but it does NOT list for only one Supplier and it lists all the inactive, obsolete and active ones as well.



What am I doing wrong?

[CJ_London]

you need to repeat the other two criteria on all three lines

[rebfein]

It worked!

Thank you, Thank you, Thank you, Thank you!

Rebecca

[CJ_London]

no problem. If you want to save some typing in the future, put you KGS PN criteria on one line and using OR -

(Like "*" & [IC] & "*" OR Like "*.......)

[rebfein]

Again, thank you. I appreciate all the help I can get. I'm not good at programming (my logic and computer logic diverge, A LOT), so any assistance is ALWAYS appreciated.

Rebecca