Dlookup

[Brigham Siton]

I am trying to do a Dlookup as one of the expressions in my query but not
working.

Tables Source: PPO
Field to Return: Type
Match Criteria: [CLMS]![NETWORK] = [PPO]![NETWORK]

Here is my expression:
DLookUp("Type","PPO","[CLMS]![NETWORK]"="[PPO]![NETWORK]")

Tried all different places to put the Double Quotes (") or the Singel
Quotes(') but to no avail.

Please help.

Thank you.

 

[Amy Blankenship]

Try no quotes. Is CLMS a form? If not, how is it relevant?

 

[Brigham Siton]

Thanks for reponse. CLMS is another table.

Tried with no quotes but not working as well.

--
Brigham Siton
Phone: (631) 780-5001
Fax: (516) 622-3501

Try no quotes. Is CLMS a form? If not, how is it relevant?

I am trying to do a Dlookup as one of the expressions in my query but not
working.

Tables Source: PPO
Field to Return: Type
Match Criteria: [CLMS]![NETWORK] = [PPO]![NETWORK]

Here is my expression:
DLookUp("Type","PPO","[CLMS]![NETWORK]"="[PPO]![NETWORK]")

Tried all different places to put the Double Quotes (") or the Singel
Quotes(') but to no avail.

Please help.

Thank you.

 

[Tom Lake]

I am trying to do a Dlookup as one of the expressions in my query but not
working.

Tables Source: PPO
Field to Return: Type
Match Criteria: [CLMS]![NETWORK] = [PPO]![NETWORK]

Here is my expression:
DLookUp("Type","PPO","[CLMS]![NETWORK]"="[PPO]![NETWORK]")

If [NETWORK] is a text field do this:

DLookUp("Type","PPO","[CLMS]![NETWORK]= '" & [PPO]![NETWORK] & "'")

If it's a numeric field, do this:

DLookUp("Type","PPO","[CLMS]![NETWORK] = " & [PPO]![NETWORK])

Tom Lake

 

[Brig]

Thanks for your reply.

Its a text field.

I tried your expression for the text but did not work. When I run the query
its prompting me for Parameter Value PPO!NETWORK.

--

I am trying to do a Dlookup as one of the expressions in my query but not
working.

Tables Source: PPO
Field to Return: Type
Match Criteria: [CLMS]![NETWORK] = [PPO]![NETWORK]

Here is my expression:
DLookUp("Type","PPO","[CLMS]![NETWORK]"="[PPO]![NETWORK]")

If [NETWORK] is a text field do this:

DLookUp("Type","PPO","[CLMS]![NETWORK]= '" & [PPO]![NETWORK] & "'")

If it's a numeric field, do this:

DLookUp("Type","PPO","[CLMS]![NETWORK] = " & [PPO]![NETWORK])

Tom Lake

 

[Amy Blankenship]

Thanks for reponse. CLMS is another table.

Tried with no quotes but not working as well.

--
Brigham Siton
Phone: (631) 780-5001
Fax: (516) 622-3501

Try no quotes. Is CLMS a form? If not, how is it relevant?

I am trying to do a Dlookup as one of the expressions in my query but not
working.

Tables Source: PPO
Field to Return: Type
Match Criteria: [CLMS]![NETWORK] = [PPO]![NETWORK]

Here is my expression:
DLookUp("Type","PPO","[CLMS]![NETWORK]"="[PPO]![NETWORK]")

Tried all different places to put the Double Quotes (") or the Singel
Quotes(') but to no avail.

Why don't you back up and tell us exactly what the relationship is between
these two tables and what the surrounding circumstances are (what the sql of
your query is), and what kind of value you are expecting to see here. I
suspect that maybe there is not a single value that would fulfill your
conditions.