dlookup

[Jacqelynl]

I have been researching syntax for dlookup function using
a foreign table as the criteria. The syntax I am using in
a test select query is:
Entrynum:= DLookUp("[SID]","Scoresheet_GLOCK_579","
[SNC_5toGLK}.[Entrynumber] = Right([Scoresheet_GLOCK_579].
[SID],3"). This brings an error....Missing ), ] or item
in query expression [SNC_5toGLK}.[Entrynumber] = Right
([Scoresheet_GLOCK_579].[SID],3")

I need help! Please!

 

[GVaught]

Note the statement is telling you what the error is..... note below

[SNC_5toGLK} <-- this should be ]

 

[jacqelynl]

thanks but that wasn't the problem. That "}" was just a
typo in this thread - still the same error using

entrynum: DLookUp("[SID]","Scoresheet_GLOCK_579","
[SNC_5toGLK].[entrynumber] = right([scoresheet_GLOCK_579].
[sid],3")

trying to find record in one table that is equal to the
right 3 characters in another table. should work, no?

-----Original Message-----
Note the statement is telling you what the error is..... note below

[SNC_5toGLK} <-- this should be ]

I have been researching syntax for dlookup function using
a foreign table as the criteria. The syntax I am using in
a test select query is:
Entrynum:= DLookUp("[SID]","Scoresheet_GLOCK_579","
[SNC_5toGLK}.[Entrynumber] = Right ([Scoresheet_GLOCK_579].
[SID],3"). This brings an error....Missing ), ] or item
in query expression [SNC_5toGLK}.[Entrynumber] = Right
([Scoresheet_GLOCK_579].[SID],3")

I need help! Please!

.