Search
Criteria using the AND, OR Operators
The AND
Logical Operator
Search conditions can be combined using logical operator AND -
eg. to list ID, Address Line 1, Areas of Property between £40000
AND £50000, use this query:
You
can switch between Design and
View
in the top left of the toolbar when your query is open. You can
view your query criteria in a magnified (zoom) mode by clicking
your right mouse button whilst in the Criteria box. From the options
select Zoom.
Search
expressions can be placed as criteria in different fields - eg.
to list the ID, Address, Area of property which is semi-detached
(S) and over £45000 in Price, use the query below:
Amend
the above query to list the ID, Address and Area of:
- Cottages
with oil central heating
- Semi-detached
houses with gas central heating
- Terraced
houses in Foorfield
The OR
Logical Operator
Search conditions can be combined using logical operator OR -
eg. to list ID, Address Line 1, Areas and Price of property in
Foorfield OR Nomemby use this query:
Amend
the above query to list the ID, Address and Area of property:
- in
Fitten or Westfield
- with
gas or oil central heating
- of
type semi-detached or flat
- of
type terraced or in Foorfield
 Contents:
Databases
Skill
Check: Databases
|
