In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem?
Mikepf
0
Newbie Poster
Recommended Answers
Jump to PostThe iif function has 3 parts (condition, true, and false). Your condition is SSN=50. If your condition is true, it will display 99, if the condition is false it will put in the SSN. This is based off how you wrote it anyway. What are you trying to get the …
All 4 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.