Hi. I would like to have a text box filled in based on the number
entered in another text box. The values are in a range format and I
don't know how to write the IF, Then statement. This is what I tried
so far:
If txt1 >= "1" Then
txt2 = "1"
ElseIF txt1 >= "30" Then
txt2 = "2"
End If
It works to some extent but what I really want to do is to say:
"if txt1 is between 1 and 29 then txt2 = 1; if txt1 is between 30 and
59 then txt2 = 2"
I don't know how to write that or if it's possible. Any ideas?
Thanks.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
