Iif statement =error in query

[ppoindexter]

I have placed this Iif statement in the field line of a query

ref: Iif([fld_tplan_res_mat_id],1([fldreference] & " " & [fld_free_text] & " " & [fldpages])," ")

and am recieving this error

"may have entered an invalid identifier or typed () following the null contant"

 

[dcx693]

There's a typo in there:
Iif([fld_tplan_res_mat_id],1([fldreference] & " " & [fld_free_text] & " " & [fldpages])," ")

 

[ppoindexter]

sorry
i dont see the typo

 

[dcx693]

The number 1 highlighted in red.

 

[ppoindexter]

i guess i am missing something here, the 1 is the criteria ..if fld_tplan_res_mat_id is 1 then i want the string (that follows)

could it be i have the wrong syntax???
thanks for your help

 

[dcx693]

Then perhaps this syntax would be what you need:
Iif([fld_tplan_res_mat_id]=1,([fldreference] & " " & [fld_free_text] & " " & [fldpages])," ")

 

[ppoindexter]

ureka!! that was exactly what i needed....thanks so much!!