Hello.

[color:blue]My business works in rolls of paper. So [color:blue]everything we do is in lineal feet. We are trying to figure out a way to add up all of the footage we've sent out and show how far around the world we've went.

For rolls....I have a summary field of all of the final footage we've sent out for each customer.

For sheets...I have a calculation field that brings the total sheets sent out into total lineal feet sent out. And a summary field to add all of them together.

My problem is adding up all of the total roll feet and sheet feet for all customers.

I have 2 summary fields and I'm not sure there is a way to add those together.

Any suggestions on what to do??

Thanks! [color:blue]

This should be doable. Can you shed some light on your structure? Are rools and sheets in two different tables or are they in the same table?

They are in the same table.

I have the two summary fields adding up correctly, but I can't figure out how to add those 2 together and get a final number. If we search through different customers I want that final footage number to stay constant and up to date, but I just can't figure out how.

Well you can use a selfjoin relationship perhaps using the cartestian join 'X' operator.

Then you can use the Sum () function on the related records.

I can not do a self join relationship because they are both summary fields. The field is lightened out so that I can not click on it. Any other suggestions?

Huh? You do a self join keyed on your primary key. Then you create a new calc that adds the Sum() of your child self join table occurence.