6 Replies Latest reply on Aug 6, 2017 9:43 AM by blackcatenterprise

    how do I calculate number techs (for example) out of TITLE field.


      This would be so simple as a SQL statement. How in blazes do I do this with fmp anyone? SO I have employee files, and they have titles. This titles can be edited so each is assigned an ID to identify it, since the title could be anything. Now I need to be able to calculate how many "X" titles are in all the records.


      I would think get the sum of X field where Y is equal to BLAH but even if this is all where and how do I do this sort of SQL like calc in FMP? Been trying everything and looking everywhere...


      TITLES are a table itself


      I hope to make some charts of this calc later.