If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
null or y=yes
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 |
Thread Tools | |
Display Modes | |
|
|