printing with yes/no criteria

[Jen0dorf]

Hi

have a table with one colum as a yes/no field.

I have created a query based on the table which contains the fields I want to print.


I then used the label wizard to create my labels.

One of the fields in the table is for who to send xmas cards to and is a yes/no field.

How do I limit the labels printed to those with a yes in the xmas field

thanks

Ian

[Jen0dorf]

Thought I'd solved it

added the yes no field to the query and then in criteria added ="true"

However got a data missmatch message
Ian

[CJ_London]

yes/no fields are actually stored as numbers -1=true and 0=false. They also have some standard formats of Yes/No and True/False which you can use as alternatives

so when you used ="True" you are comparing a number to a text which is why you are getting the error

try

=True

or

=Yes

or

=-1

[Jen0dorf]

Hi

many thanks for the quick and accurate answer

cheers

Ian