I have a table with a bunch of fields that are yes/no. If I enter true in the appropriate criteria box, it works fine. If, following the instructions in Beginner 5, I set it up for paramater input, and enter true in the parameter box, I get an error message "the expression is typed incorrectly of is too complex to be evaluated". I viewed the lessons on forms but did not find any help there. Any suggestions? TIA Al Welch
Good question. "True" in a parameter box returns a string. Your yes/no fields are technically numeric. So, you'd need to enter 0 or -1 for your parameter prompt. Yes, -1 is the value for True. Confusing... I know. Someone else recently asked me about this. I was going to do a video on it soon.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
