Is there any benefit or penalty to use the database joins we have setup.  For instance.  The second query would have:

LowestProductPrice1Q,
VendorXProductT,
VendorT,
ProductT

All left joined by the relative IDs and MinOfUnitCost-> VendorXProductT.UnitCost.  Then you can just drop the fields you need in the query without the DLOOKUP.

Maybe that would be faster then DLOOKUP with tons of records?  Or maybe I'm jumping ahead..

Keep up the great work :)

---

Reply from Rick Rost:

Brian, that course is over a year old, so I don't remember EXACTLY what the lesson covered, but it is generally faster to work with linked tables than to use DLOOKUP in a query for a large set of data. I'm sure if that's the way I did it in class, however, there must have been a good reason for it. :)