null or y=yes

I need a field to be null or yes, and would like not to have to type in yes
but just the letter y. I never use access except for one document which never
changes. However we've gotten new equipment and the document disappeared.

I've tried: y=yes, but then it put no the the non-yes fields,

IS NULL OR Y=YES, did not work

You'll need to use a one character long text field instead of a Yes/No boolen
field. Create a validation rule where only y or nulls are allowed. Of course
you'll then need to use something like an IIf statement to see Yes in forms
and reports.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Rosie1956" wrote:

I need a field to be null or yes, and would like not to have to type in yes
but just the letter y. I never use access except for one document which never
changes. However we've gotten new equipment and the document disappeared.

I've tried: y=yes, but then it put no the the non-yes fields,

IS NULL OR Y=YES, did not work