Min Query Problem

[Brennan]

Hello:

I have a query that contains the following fields:

EstimatorID
EstimatorName
ContractorID
ContractorName
JobID
JobName
JobLocation
BidID
BidAmount

An estimator can have multiple bids on the same job with
different contractors but will never have multiple bids
for the same job with the same contractor.

I need to design a query that will if an estimator has
mutliple Bids for the same job that I will select the Bid
that has the lowest value. I tried using the Min function
on the Bid amount field but that didn't work.

Any ideas would be appreciated.

Brennan

 

[Jeff Boyce]

Brennan

What happens if you build a Totals query that only includes the fields you
said you needed:

Job, Estimator, Bid

and use GroupBy on the first two fields, Min on the third?

Good luck

Jeff Boyce
<Access MVP>