hi, i have here two small questions

first, can we figure out the name of the vendor through query? i mean without using Dlookup function.

second,

vendorID: DLookUp("VendorID","VendorXProductT","ProductID=" & [ProductID] & " And unitCost=" & [minofunitcost])

in the previous syntax, the product ID and UnitCost is pulled from the Query (query 1 the aggregate query) but it is looking up in the VendorXProductT.

i am bit confused here as the syntax of the lookup mixed ( looking in a table and the criteria is from different table or query)

the same story in the following syntax

VendorName: DLookUp("VendorName","VendorT","VendorID=" & [VendorID]) he access looking in vendorT but the criteria vendor ID is pulled from the prevoius Dlookup