By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,916 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,916 IT Pros & Developers. It's quick & easy.

Expression Builder Problem

P: 1
I am trying to write a validation rule which needs to use a "then" expression but i am not skilled and i do not know how to do this.
i want to have two fields "Date given" and "Date collected" and one check box "collected?"

if "date given" is not an empty field and "date collected" is an empty field then i want "collected?" to be false (unchecked) or an error message comes up

if the "date given" is not an empty field and "date collected" is not an empty field then i want "collected?" to be true(checked) or an error message comes up

i think you may need to use the iif function but i need help.
Mar 3 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,492
You haven't described all situations here. What if [Date Given] is empty?
Mar 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.