Calculating Costs

[davefilm]

Hello,

I am Trying to figure out how to do a layout/Calculation that I need to do the following:

I already have it so that it breaks out records into sequences and calculates total costs.

Within the Total Costs there is a possibility of 3 Facilities that are placing bids. I would like to have something set up so that I can see the summary of Each vendor. The field name I have is "Facility" and there are 3 possible options. "Facility 1", "Facility 2", and "Facility 3". So I would like to calculate the costs of the found records for each facility.

Would appreciate any help on how to do this!!

THANKS FMF!