Please Guide me a solution
SELECT TblPlannenLijst.* FROM TblPlannenLijst WHERE TblPlannenLijst.IDPlanList = "& Chr(34) & IDPlanList & & Chr(34) " Order By Case When TblPlannenLijst.Plannr Like "& Chr(34) & "*-*" & Chr(34)&" Then 1 When TblPlannenLijst.Plannr Not Like "& Chr(34) & "*-*" & Chr(34)&" Then 2 End" Rst = dbs.OpenRecordset(StrSource00, dbOpenDynaset)
Getting Runtime erron On CAse
Case-When-Else
IIf
IIf(condition, true-expression, false-expression)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)