Hi again folks,
Hopefully I'm in the right forum, I'm scratching my head over this one:
BCMRP1.zip
In the attached file I have a query, qryMTLPriceSelector. This query, and others related to it, are being used to winnow down a list of prices for an assembly. The pricing is based on how many assemblies are required and I am trying to have this query output only the rows where the Diff field has the greatest value that is less than zero. I had some functionality by adding criteria to the Diff field in a second query that pulls from this one to limit the results to only those less than zero and greater than the inverse of the PriceQTY field, but as the quantity of assemblies in the field RFQQTY increased I began not seeing the results for the larger numbers as they fell outside of the criteria just described.
I've tried using MIN and MAX, but the challenge is that I need one row for each unique RFQQTY. Any thoughts?
Please let me know if I've been too vague, happy to provide more info.