Error message for DLookUp

D

dcrqueens

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.
 
J

John Spencer

TRY

DLookUp("[Member #]", "[Committee Report]", "[Member Name] = """ &
[TableName].[Member Name] & """")


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
D

dcrqueens

John I got it to work. I went back to the table that the report will be based
off, and added the fields needed from the Committee report. It is now
automatically pulling the information. Thank you very much for your help.

John Spencer said:
TRY

DLookUp("[Member #]", "[Committee Report]", "[Member Name] = """ &
[TableName].[Member Name] & """")


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
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.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Report printing multiple pages based on query 2
Change printing orientation with in an access report 1
How to pass parameters to a report 2
Show if record count more than 4
S.Y.M. Wong-A-Ton .... PLEASE HELP, I Need your INFOPATH 2013 COOKBOOK 2 1
Template with fields and premade texts.. 0

Top