Contents - Index


Query Field Selectors

This screen is used to limit your query to a specific value, a list of values, or a range of values.

Field Types Explained
Data fields may be one of the following types:

Character Alphanumeric text.
Date Date. Use format "mm/dd/yyyy".
Numeric Numeric only and may contain a decimal point. Do not enter a comma.
Monetary Same as numeric. Do not enter a dollar sign.
Logical Use a 1 for true and a 0 for false.

Layout / How To
There are five selector fields available. Data is entered into these fields depending on how the selection is to be made.

There are ten ways in which to select data. Make your choice by clicking on the letter of your choice. These selector actions are described below.

A - Include all selectors entered
Only those selectors entered (up to 5) will be included in the query results.

B - Exclude all selectors entered
The query will include all data except the data which contains the selectors entered (up to 5).

C - Include Range
The query will include only the data which falls between (inclusively) selector #1 and selector #2. Selector #1 must be less than selector #2 for this to work.

D - Exclude Range
The query will include only the data which does not fall between (inclusively) selector #1 and selector #2. Selector #1 must be less than selector #2 for this to work.

E - Greater than selector
The query will include only the data which is greater than (exclusively) selector #1. 

F - Less than selector
The query will include only the data which is less than (exclusively) selector #1.

G - Is null or blank
The query will include only the data which is null (or blank). No selectors are used. ("Null" means void of any data whatsoever. "Blank" means that the text value contains spaces. It may not seem that there is a difference between the two, but in SQL there is.)

H - Is not null or blank
The query will include only the data which is not null (or blank). No selectors are used. 

I - Is like
This will allow you to specify a partial value for the query. Only selector #1 is used. An example would be to show all last names that begin with st. In this case, you would enter st% in selector #1. You must include the "%" sign as it tells SQL to include data "that begins with."

J - Is not like
This is like "I," but will exclude any matches from the query.

Buttons
Use to save your edits and return to the query screen.

Use to clear all of the selector fields.