summary field within a record

[justusmin]

this is a logic problem. say i have 5 fields, some of which may be empty for a given record. i want a summary field to check all 5 and if any of those are positive, then give me a positive result in a new field. in addtion ot posting, cc-ing a response to [email protected] would be greatly appreciated.

thanks

justus

(filemaker pro 5)

[Vaughan]

What do you mean by "positive"? Do you mean "greater than zero"?

This could be done with a calculation field...

If (field1 > 0 or field2 > 0 or field3 > 0 or field4 > 0 or field5 > 0, 1, "")

This returns "1" if any of the fields contain a number greater than 0.

[Lee Smith]

You can mark this, or any other thread, as a favorite. In your profile there, is an option to be notified by email when someone responds to a thread marked like this.

This is a better way to handle questions, then to ask to be sent something back channel. This way, nothing is hidden from the group, and everyone can learn from the discussion.

Lee