Sum a particular field for multiple records

[raouls]

I am looking to sum a field called yards across multiple records automatically for all records not omitted. I have simplified my database and wanted to see if someone can help me with the formula. Sum only shows the field that is selected. I would like to ctrl + F to find a particular showroom, then see how many yards are in that showroom. Thanks.

Sum_tool.zip

[comment]

First, change your Yards into a Number field. Then use a Summary field, defined as Total of Yards. Summary fields summarize the found set.

[raouls]

THANK YOU!!! Works great!

I had this as text field. D'oh!