Hey Thrill seekers!

I'd like to create a calculation, could be a summary field as well I suppose, that totals records that match a specific criteria. I've a summary value that of course totals the "Risk" field in a database, but I'd like it to only total the "Risk" value in records that also have an "Open" value in another field in the same table.

Any Ideas?

Summary fields total the records found. So, by finding only Open, your summary field will show the total risk for those open found records.

You could create a calc field, OpenRisk = If ( status=Open; risk; "") and then use a summary field on OpenRisk.

You can avoid summary fields if you use a relationship from another table into the table that contains the risk values.

I've got the first solution to work, but haven't seen how to do it without the summary field. I do have the two tables linked in a relationship, but haven't seen how to eliminate the Summary field.

What two tables?

I'm gonna try just adding my question since it's basically the same...

I need a field that I can put onto a form view record to sum up quantity on matching product records based upon UPC so I get a total quantity count.

Sometimes a product gets duplicated by mistake but mostly on purpose and I need to see how many total there are.....

Thanks !

Headed to the DR for a checkup and will check in later....