concatenate where clause

C

carrie schmid

concatenate("SELECT accomp & SIM2 FROM R010SIMTABLE WHERE ssan=""" &
[ssan] & """")


I would like to add another linked field from r010simtable where shortid =
shortid , but I haven't had any luck.

Any help would be appreciated. thanks.
 
F

fredg

concatenate("SELECT accomp & SIM2 FROM R010SIMTABLE WHERE ssan=""" &
[ssan] & """")

I would like to add another linked field from r010simtable where shortid =
shortid , but I haven't had any luck.

Any help would be appreciated. thanks.
Click to expand...

What's the datatype of [shortid]? Number or Text?

Number?
WHERE ssan=""" & [ssan] & """ AND [ShortID] = " & [ShortID])

Text?
WHERE ssan=""" & [ssan] & """ AND [ShortID] = """ & [ShortID] & """")
 
Top