2-part query

[ys]

How do I write a query that gives me the
tblParts.LotNumber with the lowest tblEval.PartCount for
each unique tblParts.BrandName?

 

[Tom Ellison]

Dear ys:

I'll give a general answer to your question for now. You don't have
enough details here yet.

Using a correlated subquery, determine the minimum value of PartCount
for the group of rows that meet the criteria (if any). Filter to
those rows where the PartCount is that minimum value.

To get specific help, please write and post a query that shows all the
rows, not just the ones that have the "lowest part count." I would
need you to post that query here. Include specific information about
which column or columns form a group for each of which you want to see
only the minimum PartCount. I'll try to code from that to give you
what you want. Be sure to include that PartCount in the SELECT
portion of your query.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts