Hi,
I am working on a database and I need to create query, finding all the products where the SIZE mm includes 15 and SHELF is between 2 and 4 (inclusive) or between 6 and 9 (inclusive).
Anyone help with this?
Thanks in advance...
Hi,
I am working on a database and I need to create query, finding all the products where the SIZE mm includes 15 and SHELF is between 2 and 4 (inclusive) or between 6 and 9 (inclusive).
Anyone help with this?
Thanks in advance...
Last edited by concrete; 09-07-2016 at 09:31 AM. Reason: adding attachement
Do this on two Criteria Rows in your Query Builder (which then treats it as an "OR" situation).
Criteria Line 1:
Under SIZE: Like "*15*"
Under SHELF: Between 2 and 4
Criteria Line 2:
Under SIZE: Like "*15*"
Under SHELF: Between 6 and 9
Thanks Joe,
You are welcome!
When using the Query Builder to create queries, the thing to remember is the following:
- Multiple Conditions entered on the same row are treated as "AND"
- Conditions entered on multiple rows are treated as "OR"