How to write a query

[concrete]

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...

[JoeM]

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

[concrete]

Thanks Joe,

[JoeM]

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"