Problem Query

[Lynn73]

Help!
I want to add a statement to my access query which lists one field if another field matches the criteria

STATUS PROCCODE
Complete ABCD
Incomplete DEFG
Complete JHLM
Incomplete BDEF

I only want to show the Proccode if the Status field is Complete, if its incomplete I want it to be blank.

Can anyone help?

 

[pbaldy]

IIf(STATUS = "Complete", PROCCODE, "")

 

[Lynn73]

That works a treat.
Thanks for your help