Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding a value in Summary Field 1

Status
Not open for further replies.

VAhorsevet

Technical User
Nov 9, 2006
5
US
I want to find all clients with an outstanding balance in a summary field. Can this be done?
 
You can't enter search criteria in summary, container, or global fields.

For summary fields, this is the reason:

Summary fields are associated with groups of records. The value in a summary field can change depending on where you place the field on a layout, how many records are in the found set, and whether the records are sorted.

Data in a summary field reflects records currently being browsed; either all the records or a group of found records. If you change a value in one of the fields on which the summary is based, or if you change the found set, FileMaker Pro recalculates the result in a summary field.

The keyword is 'reflects'.

It depends how the structure of your database is, you have to find another way to retrieve the outstanding balance.

Somewhere in your file you're calculating the paid amount against the total due payment.
Flag the records with a difference (or not 0 ) with a calculation.
Search on this field and show the records in a list view table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top