Return to FileMaker.com
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 ?
If you create a field, Field 3 Cos(RADIANS (field1)) * cos(RADIANS (field2), then you can search in MyTable for the values in Field1, Field2, and the Field3, in one find request.
Retrieving data ...