There are several key elements to the Advanced Search.
First of all, you can select fields to search, in much the
same way as the simple search, but you can specify how several of these searches
link together by using the AND, OR and NOT buttons below each criteria section.
The Display box allows you to select which fields from the database you
want to display in the list. To select multiple items from the list, hold down
the Ctrl button on your keyboard and use your mouse to select each value.
The Query box allows you to type in your own SQL query to select data
from the table.
The Load Query button allows you to see a list of SQL
query to be loaded in the Query box.
If you click the Load Query button, then
a list of SQL statements in a dropdown menu will be displayed. You will just
click one of the SQL statements to be loaded.
Once you have entered in
your search terms, click the Display button to see your results.
Again, you can also select how many results you want to display on the page.
Note: Selecting 100 records will slow down the
display of this page.