Query form for table keywords
You can use this form to generate a query against the data in
this table. In the entry box for any field you can enter
a Boolean expression indicating the value or values you require
that field to match. For example, if you put = 45 in
a box, then the corresponding field must equal 45 for a record
to be selected. If you need help with the formulation of
these expressions, try the Beginner's
Guide to SQL Selection Expressions. You can also request
basic stat functions min, max, sum, avg on any numeric column; however,
obviously if you choose this option, you cannot print regular column
values as well.
Selecting fields to print: By default the first three fields will be printed.
Just deselect the Print button for fields you do not want in
your output, or select it for those you wish to add.
Performance: Column names appearing in italics as well as bold, like this,
indicate that this column is indexed in the database server for
faster searching. If you can use criteria for these columns to narrow
your search, your query will run much faster!
If you want to know what the fields mean, check the
data dictionary information for this table.
You may also want to use the browser form for this table to see one record at a time.