I realise I've got this completely wrong, thought it would be extremely useful to have the 'dateupdated' field on the LowestProductPrice2Q, so attempted to add that in to my query - this is what I put:
astUpdated: DLookUp("VendorID","ProductXVendorT","ProductID=" & [ProductID] & "AND DateUpdated=#" & "DateUpdated" & "#")

Obviously I am struggling with the Dlookup function, could you please guide me as to where I've gone wrong with this as it's returning an error.

Many thanks

---

Reply from Richard Rost:

DLookUp("VendorID","ProductXVendorT","ProductID=" & [ProductID] & "AND DateUpdated=#" & "DateUpdated" & "#")

DateUpdated is a FIELD not a VALUE. It should not be in quote. And, you're missing a space in front of "AND" again.

DLookUp("VendorID","ProductXVendorT","ProductID=" & [ProductID] & " AND DateUpdated=#" & DateUpdated & "#")