How to create a query using calculations on table fields?
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 ?