1. KH Guest

I have 7 variables that contain different dates. I need each of the following to meet certain conditions before the form will submit to a database but I don&#039t know how to set up my If Then statement. It basically should say that if all of the conditions are true (greater than 4 and less than 90) then<BR>submit to database and send the email out<BR>Else<BR>Reject statement will display. How do I create the IF THEN statement with all of these conditions below? Thanks<BR>If str1Elapse &#062;= 4 AND str1Elapse &#060;= 90 Then<BR>If str2Elapse &#062;= 4 AND str2Elapse &#060;= 90 Then<BR>If str3Elapse &#062;= 4 AND str3Elapse &#060;= 90 Then<BR>If str4Elapse &#062;= 4 AND str4Elapse &#060;= 90 Then<BR>If str5Elapse &#062;= 4 AND str5Elapse &#060;= 90 Then<BR>If str6Elapse &#062;= 4 AND str6Elapse &#060;= 90 Then<BR>If str7Elapse &#062;= 4 AND str7Elapse &#060;= 90 Then<BR>

2. Senior Member
Join Date
Dec 1969
Posts
1,013

You could do a stonking if then statement eg :<BR><BR>If str1Elapse &#062;= 4 AND str1Elapse &#060;= 90 Then <BR> If str2Elapse &#062;= 4 AND str1Elapse &#060;= 90 Then <BR> If str3Elapse &#062;= 4 AND str1Elapse &#060;= 90 Then <BR> If str4Elapse &#062;= 4 AND str1Elapse &#060;= 90 Then <BR> &#039submit to database<BR> &#039send email out<BR> End If<BR> End If<BR> End If<BR>End If<BR><BR><BR>

3. Race Byxbee Guest