dlookup

  • Thread starter Thread starter Jacqelynl
  • Start date Start date
J

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!
 
Note the statement is telling you what the error is..... note below

[SNC_5toGLK} <-- this should be ]
 
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 ]

Jacqelynl said:
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!
Click to expand...


.
Click to expand...
 
Back
Top