IFF Statement Help Required For Attachments

[aamer]

I am trying to make a querry where if there is an attachment in table it says YES and if there is no attachment it says NO

I am using the following but its not working

Detail: IIf([purattach]>0,"Yes","No")

[recyan]

Have you tried :

Detail:IIf([purAttach]=-1,"Yes","No")

Thanks

Edit : I missed out totally on the keyword "attachment" in your post & assumed it as a Yes / No Field.

Till someone comes along, Check out if below gives some guidelines :

Detail: IIf(IsNull([purAttach_1].[FileData]),"No","Yes")