To much Information

[stm8ter]

I hope this makes sense.
I have a Report Based on a query.
The query is based on the estimator, and a Date Range.
The Report has the Estimator, Project Name, Bid Date, Bid Amount, Award Date & Award Amount. The Report then Calculates the Total Bids, and the Total Awards, divides the Awards by the Bids for a Hit Rate Percentage. The problem is that a bid may be forwarded to several contractors for the same project, however only one contractor can award the project. This is producing incorrect results. Example $1,000,000.00 x 15 Contractors totals $15,000,000.00, this is needed to track where the bids were sent; however this does not mean the estimator bid $15,000,000. In addition if the estimator is awarded this bid the hit rate percentage should be 100%, however the current results are 6%. How can I filter out the duplicates? The duplicates are a necessary part of tracking in other reports so the duplicate entries must remain. Thank You in advance for your help, I have a limited amount of knowledge on Access and lost on code issues.

 

[stm8ter]

Patience Grasshopper, sorry if I had patience I probably would not be having this problem.
I see it has been read, but no comments. I am concerned that I am not clear on the issue. Now I am thinking I may be on the wrong path here. Maybe the problem is not with the report so much as with the form and table. Rather than duplicating the bid information in the bid form for each contractor, I am thinking of creating a sub form to store the contractors. This way the Bid would not be duplicated, and there would be a list of contractors who have received the bid. This may create a problem in some of my other existing reports, but may be the correct thing to do.

I guess the progression would be
Project Form
Enter all Project Information (Currently exists)
Bid Form
Enter the
Bid Date, Bid Amount,
Award Date, Award Amount (Currently Exists)
Distribution Form
Enter each Contractor receiving this bid
(New Sub Form)
Does this make sense?

Please point and I will try to find my way.