null or y=yes

  • Thread starter Thread starter Rosie1956
  • Start date Start date
R

Rosie1956

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.
 
Back
Top