| AppendsubCity |
What:
When this query is run it prompts you for a state abbreviation.
After entering the state value it appends all of the city
records for that state from subZipCodeList to subCity.
How: Import this query into ClientsT2000.mdb, and then
run. |
| AppendsubCounty |
What:
When this query is run it prompts you for a state abbreviation.
After entering the state value it appends all of the city
records for that state from subZipCodeList to subCounty.
How: Import this query into ClientsT2000.mdb, and then
run. |
| AppendsubZipCode |
What:
When this query is run it prompts you for a state abbreviation.
After entering the state value it appends all of the city
records for that state from subZipCodeList to subZipCode.
How: Import this query into ClientsT2000.mdb, and then
run. |
| QnthRecord |
What:
Chooses every 10th record between 2 dates.
How: Import this query and the module Utilities into
either CFW2000.mdb or ClientsT2000.mdb, and then run. |
| Text
to the left of a hyphen |
What:
This example pulls the text to the left of the hyphen in
casenumber. This
can be easily modified for other uses, such as pulling a last
name to the left of a comma to separate first and last names stored
in one field.
How: Import this query into either CFW2000.mdb or ClientsT2000.mdb,
and then run. |
