I now have the Dlookup working in "Update Vendor Pricing", I done this by adding the "ID" Field From "VendorXProductT" to Query "ImportProductPricingXYZWholeSaleQ" Looking back on the video It seems I did miss the part where he added the ID field in, so I will go back on the the previuos lesson and its more then likely an error on my part, spent a lot of time on this part of the course, the upside is, I do now know the Dlookup Function inside out and a few off the problems that can come with it, this one needs to be obsolutly spot on.
Reply from Alex Hedley:
Yeah it's a pain but as you say great way to learn!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.