Register and Join the most happening forum of Sikh community & intellectuals from around the world.
Discussion in 'Information Technology' started by dg2k, Jul 28, 2006.
I am trying to change Y/N to Smoker/Non-Smoker so I can use that text in Mail
Try something like this in a query:
Field: IIF([FieldName] = 0, "Non-Smoker", "Smoker")
where [FieldName] is the name or your Yes/No field. Make the appropriate
substitution for the name.
Tom Wickerath, Microsoft Access MVP
> I am trying to change Y/N to Smoker/Non-Smoker so I can use that text in Mail
> Merge letters.