To Filter Several Records in 2 Different Fields

[Ultra King]

Hello All!

I need help to filter my queries...
It have several fields, and the fields that I want to filter is ItemNo and SellingPrice.

The problem is ItemNo has many different SellingPrice. I put a parameter in SellingPrice field as >=75 only for ItemNo "49565", but still i want to show other record in ItemNo and do not have filter in SellingPrice field.

 

[Geotch]

Look at this picture, should get you what you want.

 

[Ultra King]

Thank you for your reply..

I have tried using the way from the picture, and my query look like this


But the result that I get after run the query is not what I expect it should be... Result ...

Can you look what is wrong with my query...

 

[pr2-eugin]

Add the >= 75 in the next line too..