AnsweredAssumed Answered

How to create a query using calculations on table fields?

Question asked by fabiuz on May 27, 2012
Latest reply on May 27, 2012 by Sorbsbuster

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!

Outcomes