query

[associates]

Hi,

wonder if anyone might be able to help me here.

In the query, I have two tables, Projects and Plan Summaries.

They both have one field in common which is of type number, "PS_ID"

So in the query, i was trying to perform dlookup as follows
DLookUp("[PN_Code]","[Plan Summaries]","[PS_ID]=[PS_ID]")

What i want to see in the output is PN_Code from Plan Summaries table.

When i run the query, i got the incorrect result there.

Thank you in advance

 

[Rabbie]

Try this

DLookUp("[PN_Code]","[Plan Summaries]","[Plan Summaries].[PS_ID]=[Projects].[PS_ID]")

 

[associates]

Thank you Rabbie,

I tried the code but got the following error

quoted : "This expression you entered as a query parameter produce this error: 'microsoft office access can't find the name 'Projects.PS_ID' you entered in the expression' "

That's what makes me wonder too. It didn't like it.

Thank you in advance

 

[KeithG]

why not create a join of the field