Thomas,
It looks like you have 2 tables, Camps and Bids.
Each Camp has many Bids, correct?
Any you track the 'status' of the bid on those records, correct?
(If so, and I hope this is your set up)
You will want to summarize 4 values from the [Bids] table up to the [Camp] table.
# of Bids (this is a total, regardless of result/status)
# of Bids Awarded (# where the status = "Awarded")
# of Bids Lost
# of Bids Cancelled
Now for each camp you will have the 4 values needed to do any type of calculations or ratios.
i.e. Won/Lost ratios, or % Won, etc.
This also puts the 'reporting' on the level of the [Camp] table, and you can compare camps better.
