1 Reply Latest reply on May 27, 2012 1:36 PM by Sorbsbuster

    How to create a query using calculations on table fields?

    fabiuz

      Title

      How to create a query using calculations on table fields?

      Post

      Hi,

      I need to find records based on some field values AND I have to filter records even by making some calculations on table fields.

      So I need something like this:

      SELECT * FROM mytable

      WHERE field1 >= 4 AND field2 < 22.4 AND cos(RADIANS (field1)) * cos(RADIANS (field2) <= 0.0213

       

      How is it possible to do something like that in FMP ?

       

      Thanks!