[Return to contents]

Tricky finds

Last updated: 4 Jul 1998

If you have exhausted the possibilities of Find and the Find Assistant then you will probably have to create a formula to find the records for you (see the Help files on how to do this). However, remember that the formula is lost once the find is performed. This can be annoying if you don't enter it correctly or you need to modify it for any reason. One way around this is to cut and paste the formula to and from a text document so that you retain a copy of it. However more permanent solutions are:

• create a calculated field that simplifies the find
• create a looping macro to do the search and set a Boolean field to TRUE if the records matches the criteria (then just search for all those records with TRUE in the Boolean field. Don't forget to fill the Boolean field with FALSE before you use it next time!)
• create a variable field and do a worksheet find on that variable field. You do this by placing @VarField (where VarField is the name of your variable field) in the field that you wish to search.