Sum Problem

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello:

I have a database that tracks bids for an electrical
contractor. There can only be one job but the contractor
can have multiple bids on the same job through different
contractors.

I have a report that groups all project information by
project manager. In the group footer, I am performing
several calculations, one of which is a sum of all bids
outstanding.

The following code in in the Bid Total text box:

=Sum([tblBids_BidAmount])

If a project manager has mutliple bids on the same job, I
would like to include only the bid with the lowest value
in my total. We use the value captured in this field to
perform other calculations and some of them are thrown
off if there are mutliple bids.

Is there any way I can accomplish this at the report
level?

Any ideas would be appreciated?

Brennan
 
If you mean what I think you do then in your group footer put a text box
with

=Min([tblBids_BidAmount])

Evi
 
Back
Top