6 Replies Latest reply on May 4, 2016 1:13 AM by appt

    Finding based on summary fields

    appt

      This is driving me mad

       

      I have a simple file for students to create that has a client table and a job table.

       

      Each client can have many jobs.

       

      Each job incurs a cost and I want to keep a record of the total amount charged based on several separate jobs being completed.

       

      So far so good the summary files adds up all of the jobs costs. This is done on the client layout with a portal to the jobs.

       

      However I now need to search for customers who have total jobs costs adding up to > 100

       

      I can't create a Find script based on a summary field. So I tried creating a second field that was a calculation with the result simply the summary field but running the find does not work and returns all records.

       

      Surely the calculation field has the numerical value that is provided by the summary.

       

      Any help much appreciated.