Mail Merge problem

[cheyenne2002]

I have a table with a few fields that are Yes/No which makes them True/False in the eyes of Access. When I try to use some of these fields in a mail merge I'm getting FALSE where I thought I would get nothing and TRUE where I thought I would be getting a check mark, because that is what I did on the form.

Is there a way to have the mail merge give me nothing if false and Yes or a check mark if it is True?

I'm still quite new to Access so I'm unfamiliar with may of the built in feature and not good at heavy SQL programming.

Any assistance would be greatly appreciated as I need to get the labels in this mail merge done "yesterday" we all know how that goes.

Thanks in advance.
Sharon

 

[dhookom]

You can merge from a query that has a field defined something like:

NewYesNoField: IIf([YesNoField], "Yes","")

Duane MS Access MVP

 

[cheyenne2002]

Thank You, I'll give that a try.

Sharon