How to entering values in a Find

When performing a find with number values, you can use the greater than sign (>) or the less than sign (<) (E.g. To find all values less than $500, enter: <500 or to find all values greater than $500, enter:>500).

Numeric Tool Palette

FileMaker Pro contains a symbol tool palette which can be used when performing a search or Find.

  1. Click on View > Status Toolbar.
    A flip book will appear in a grey bar on the top of the screen.
    Numeric Tool Palette
  2. Use the screen sizing tool in the right hand bottom corner to reveal Insert – Operators.
    The directory of symbols will appear.
    Image
  3. Make sure your cursor is in the field to which you wish add the symbol. Click on Operators.
    Here is a chart to explain the symbols and show how they can be used in FrameReady.Screen Shot 2014-11-14 at 5.31.35 PM