Previous: 109: Selecting from a Specific Field

If you see something in your database and want to see more items that are similar, just right-click on the data and choose Select Same from the pop-up menu. For example if I see a person named Sandra and want to see if there are any more, I right click on the name and choose Select Same. It turns out there are four Sandras in this database.

You can repeat this process over and over, for example to select all records in Ohio. Remember, you have to right click, a regular click simply selects the cell. If you are using a trackpad you can usually click with two fingers to pop-up this menu.

If a database field contains dates, the pop-up menu allows you to select a range of similar dates — either a day, a week, a month, a quarter or a year. The mailing list database doesn’t have any dates, but here’s an example of selecting checks in January from a checkbook database.

See Selecting with the Context Menu to learn more.

Next: 111: Zip Code Distance Searches

See Also

• Searching -- searching a database to find or select information.
• Selecting with the Context Menu -- searching for information related to the current cell.

History