 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / January 2005Dlookup not working properly
Good Afternoon, Happy, Safe & Blessed New Year to Everyone! We have an Access 2003 application with SQL 2000 server on the backend. I recently added another table into our SQL database and linked it into Access. I'm trying to run a Dlookup statement to pull a price from the new table based on the product id(part#) but it returns a null or empty field. Can anyone advise? See below: Quo!UnitPrice = DLookup("[PECOCost]", "dbo_PartsDiscount", "[ProductID] =" & [Quo]![ProductID]) I do not get an error message, it just doesn't return a value. Any ideas? Thanks! Sincerely, Anthony Smith In God We Trust! Hi Anthony, If the field "ProductID" is defined as text field, then you have to put quotes around them. Quo!UnitPrice = DLookup("[PECOCost]", "dbo_PartsDiscount", "[ProductID] ='" & [Quo]![ProductID] & "'") > Good Afternoon, > [quoted text clipped - 16 lines] > > In God We Trust! Yes it is a text field. Thanks for the help, it works! Have a blessed day! > Hi Anthony, > [quoted text clipped - 28 lines] >> >> In God We Trust! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.