Syntax Error Missing Operator in query Expression

[murugesh1mca]

WHERE " & 
   IIf(Me.EXAM = 0, 
      "", 
      "EXAMLb.EXAM = " & Me.EXAM & " And ") & 
   IIf(Me.exam_grp = 0, 
      "", 
      "group.type = 2 
         And group.id = " & Me.exam_grp & " 
         And ") & 
   IIf(Nz(Me.work_grp, 0) = 0, 
      "",
       "group.type = 2 
         And group.id = " & 
            Me.work_grp.Column(2) & " And ") &
   "Trim(Nz(link2.RESULT, '')) = '' 
ORDER BY EXAMLb.EXNAME")

[murugesh1mca]

Got the answer.
Thanks for looking

[jimatqsi]

I gave up on this style of string building a while ago. It drives me crazy to try to read an expression like this. What helps me keep quotes and commas straight is something like this:

strwhere = "Where [stringfieldnameX]='\stringfieldnameX\' AND [numericfieldnameY]=\numericfieldnameY\ ... "
strwhere = Replace(strwhere, "\stringfieldnameX\", Me.x)
strwhere = Replace(strwhere, "\numericfieldnameY\", Me.Y)
 

When I started doing that suddenly my code became more readable, less subject to missing quotes, too many quotes etc ....

Jim

[zmbd]

Please post your solution so that others with a simular question can also benifit from your hard work.