Access Query excluding unwanted emails

[Jimmy2128]

Dear Sir,
I have the following statement that put a Member Roster, Currently prints everyone has email listed, but I need to exclude all the member that check the NO_EMAIL check box.
How can I write and IIF statement that exclude the unwanted email...

Thanks



AS BADGE_ADDR_EMAIL_PHONE_FAX,
IIf(dbrder_Badge.TITLE<>'',dbo_Name.TITLE & Chr(13) & Chr(10),'')
& IIf(dbrder_Badge.COMPANY<>'',dbrder_Badge.COMPANY & Chr(13) & Chr(10),'')
& IIf(dbrder_Badge.COUNTRY<>'',dbrder_Badge.COUNTRY & Chr(13) & Chr(10),'')
& IIf(dbo_Name.WORK_PHONE<>'',dbo_Name.WORK_PHONE & Chr(13) & Chr(10),'')
& IIf(dbo_Name.EMAIL<>'',dbo_Name.EMAIL & Chr(13) & Chr(10),'')
& IIf(dbo_Name.CHAPTER<>'',dbo_Name.CHAPTER & ' / ' & qChapters.TITLE,'') AS BADGE_ADDR_EMAIL_PHONE_NOFAX, dbrders.STATUS

 

[traingamer]

Don't use iif, use a WHERE clause to select only those with the box unchecked

Where ...NO_EMAIL=False...

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill