Report Calculations

[Brennan]

Hello:

I have a user that has a database that keeps tracks of bids that the company
submits to general contractors. One of the reports is a pending bid report
that reports on the status of bids that have already been submitted. Each
Job has a unique job ID. A job can have mutliple bids on it, each of which
has a unique Bid ID. The report is grouped by project manager and has group
calculations that sum the bids as well as calculate an average Bid size.
The calculations are done in 2 text controls in the group footer

The user has two problems with the report: One is that he wants to exclude
any Bid with a 0 dollar amount that figures out the calculation for the
average Bid size.

The other problem is that when there are multiple bids on the same job, the
user only wants to include the lowest Bid amount in the footer sum. If there
are mutliple bids and they are the same, he only wants to include one of them.

I am absolutely stumped on how to approach this at the report level. I
tried using the min function in the query but that didn't work. It looks
like I'll need to write some sort of code but I don't know where to start.

Any comments would be appreciated

Thanks