concatenate where clause

  • Thread starter Thread starter carrie schmid
  • Start date Start date
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.
 
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] & """")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group By problem 4
Update Multiple Columns in Table 4
Concatenate with ORDER BY clause 2
ODBC Order by question 2
concatenate 1
Finding and updating records 6
Concatenating Fields 5
For Duane Hookom... (concatenate fields)... 5

Back
Top