CODEWITHSUNDEEP
sqlms-access
Vivek
Vivek

Reputation: 1461

Query Syntax help!

I am running this query in Access 2007 and getting a syntax error on this query

UPDATE INQuery SET Awords=(SELECT Coalsce("SELECT (parentdesc & '/' & keyword) From Awords     LEFT JOIN INQuery ON Awords.id=INQuery.item_id",";")) 
WHERE Awords.id=IN_Query.item_id;

System error in query expression '(SELECT Coalsce("SELECT (parentdesc & '/' & keyword) From Awords LEFT JOIN INQuery ON Awords.id=INQuery.item_id",";"))'.

When I run the query expression separately I get the desired result.

NOTE: To see what Coalsce function is please refer VBA + String splitting

Upvotes: 0

Views: 92

Answers (2)

Jaymz
Jaymz

Reputation: 6338

Do you actually need the additional SELECT? 

UPDATE INQuery SET Awords=Coalsce(...) WHERE ...

Upvotes: 3

Kit Z. Fox
Kit Z. Fox

Reputation: 674

Could it be that it's Coalesce not Coalsce? (typo?)

Upvotes: 0

Related Questions