Find a value in a column
1. Click the Find  button
on the toolbar or press CTRL+F on your keyboard.
2. In the Find What box, type the value you want to find.
If you do not know the exact value you want to find, you can use the
Any Part of Field option in the Match drop-down list.
3. Set any other options you want to use in the Find and Replace dialog
box.
4. Click Find.
Find button
After you click the Find button the program will select records that
match the specified criteria. When the first value is found, the button
changes the caption to Find Next. Every time you click it, the program
finds the next record.
Find All button
If you click the Find All button, the program selects all records that
match the specified criteria at once.
Options
Find What
Enter the information you want to search
for.
Look In
Select a column to search through all records.
This is usually quicker, especially if the column is indexed. Or, select
the All Fields option to search through all columns in all records.
Match
Select one of the match types:
|
Match type |
Example |
|
Any
Part of Field |
"berg" finds Bergen and Heidelberg. |
|
Whole Field |
"London" finds London, but not Londonderry. |
|
Start of Field |
"berg" finds Bergen, but not Heidelberg. |
|
Does not contain |
Finds the records that do not contain the specified
value. |
|
Greater Than |
"3" finds 4, 5, 6 |
|
Less Than |
"3" finds 1, 2 |
|
Is Null |
Finds all records where the specified column does
not contain any value. |
|
Before
Date |
Finds values before specified date. |
|
After Date |
Finds values after specified date. |
Note:
you cannot use ’Any Part of Field’ and ’Start of Field’ criteria with
numeric columns.
Search
Select a search direction: Up (toward the
first record), Down (toward the last record), or All (through the entire
table).
Related Topics:
About
Search and Replace tool
Replace
values in a table
Using
criteria to retrieve certain records
Compare Tables
Using
wildcard characters
| 
