AnsweredAssumed Answered

Finding based on summary fields

Question asked by appt on May 3, 2016
Latest reply on May 4, 2016 by 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.

Outcomes