This is nuts. I took out the 'tbl001_ClientContactStatus.SecondaryMarketSup' bit from the SELECT section and the 'true' bit worked.
However, it only works if there is one WHERE clause. Maybe the mail merge query function only allows one WHERE clause?
If so, might there be a workaround (I...