Hi
Can anyone help I have a database that I want to query with three conditions using advanced filter, see attached doc, Im not sure what to put in the filters for each to get the desired result
QUERY
Show venues that meet all three criteria
Criteria 1
SHOW VENUES THAT ARE NOT IN THE FOLLOWING CITIES: ARBROATH, DERBY, NEWPORT
Criteria 2
Only show venues with capacities in either of the three rooms that are between 100 and 200 but include blanks
Criteria 3
Only show venues that have type T or blank
result should be
Brunton Theatre
Thanks in advance
Dave
Bookmarks