If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error Message for DLookUp
Hello All,
I have a query with the following fields: Member Number Member Name State Review Date I have 2 tables: Committee Report and Delivery Tracking. I have joined the 2 tables in the query by the unique member number. The issue I am having is that I am trying to create a report based on the query but cannot seem to get it to work. What I would like is for once the member number is selected in the Delivery tracking database the Member Name,State,and Review Date to be pulled from the Committee Report table. I have tired using the following information by entering it into the criteria section of the query but I get the following error message: DLookUp("[Member #]", "[Committee Report]", "[Member Name] = " & [Member Name]) The specified field [Member Name] could refer to more than one table listed in the From clause of your SQL statement. Below is the Yes, I do have a field called Member Name, State and Review Date in the Delivery tracking Field because I thought it was needed in order for the query to deliver the information back in the query. Can someone please advise where I have gone wrong? Thank you in advance. |
#2
|
|||
|
|||
Error Message for DLookUp
One has to assume that [Member Name] is Text, and you have the syntax as if
itit were Numeric. DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member Name] & "'") -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
#3
|
|||
|
|||
Error Message for DLookUp
Sorry, that should be
DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member Name] & "'") Linq Adams wrote: One has to assume that [Member Name] is Text, and you have the syntax as if itit were Numeric. DLookUp("[Member #]", "[Committee Report]", "[Member Name] = '" & [Member Name] & "'") -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200910/1 |
Thread Tools | |
Display Modes | |
|
|