Error message for DLookUp

dcrqueens · External Since: Oct 30, 2009 Posts: 2

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.

John Spencer · External Since: Jul 15, 2009 Posts: 47

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

dcrqueens wrote:
> 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.

dcrqueens · External Since: Oct 30, 2009 Posts: 2

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" wrote:

> 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
>
> dcrqueens wrote:
> > 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.
> .
>