calculated control

awake2424

Registered User.
Local time
Today, 02:28
Joined
Oct 31, 2007
Messages
479
I would like to have a textbox on a form and in the control source I have:

([OrderDate] - [DOB] <+ 30, "Yes","No"

Is this correct in order to check to see weather a sample is less than 30 days and if it is in that textbox Yes appears, otherwise No? Thank you.
 
That would cause an error. More like:

=IIf([OrderDate] - [DOB] < 30, "Yes","No")
 

Users who are viewing this thread

Back
Top Bottom