Complex Query Problem

[bobquan]

I have a database with a number of fields Program, LTV, Amount, Price, Rate,
Fee.
Each row has the same Program, a given list of LTV's, Amounts and Prices. I
want to retrieve only the lowest Rate and Fee at each give each program, ltv
and amount.

I used an update table query but it is inconsistant in returning the lowest
rate and fee even though the table from which i am selecting is sort
correctly.

Any help would be greatly appreciated.

thanks

 

[Arvin Meyer [MVP]]

Try using a Totals query with Group By as the Total criteria in every field
but either Rate or Fee and Min in the Totals row of that field. Assuming
that the row with the lowest fee will also have the lowest rate. If that's
not the case use the Min criteria in both fields.