G
Guest
trying to use a Select Case statement for the following which uses a
variable, and it's not working??? thank you in advance!!
Dim INPLEDGE
INPLEDGE = ([First Contribution] + [Second Contribution] + [Contribution] +
Pledge)
Select Case True
Case INPLEDGE >= 25000
Forms![Form]![COMMITTEE LEVEL] = "BENEFACTOR"
Case INPLEDGE >= 10000 And INPLEDGE < 25000
Forms![Form]![COMMITTEE LEVEL] = "SPONSOR"
Case INPLEDGE >= 5000 And INPLEDGE < 10000
Forms![Form]![COMMITTEE LEVEL] = "PATRON"
Case INPLEDGE >= 1000 And INPLEDGE < 5000
Forms![Form]![COMMITTEE LEVEL] = "CHOICE"
Case INPLEDGE >= 500 And INPLEDGE < 1000
Forms![Form]![COMMITTEE LEVEL] = "SUPPORTER"
End Select
variable, and it's not working??? thank you in advance!!
Dim INPLEDGE
INPLEDGE = ([First Contribution] + [Second Contribution] + [Contribution] +
Pledge)
Select Case True
Case INPLEDGE >= 25000
Forms![Form]![COMMITTEE LEVEL] = "BENEFACTOR"
Case INPLEDGE >= 10000 And INPLEDGE < 25000
Forms![Form]![COMMITTEE LEVEL] = "SPONSOR"
Case INPLEDGE >= 5000 And INPLEDGE < 10000
Forms![Form]![COMMITTEE LEVEL] = "PATRON"
Case INPLEDGE >= 1000 And INPLEDGE < 5000
Forms![Form]![COMMITTEE LEVEL] = "CHOICE"
Case INPLEDGE >= 500 And INPLEDGE < 1000
Forms![Form]![COMMITTEE LEVEL] = "SUPPORTER"
End Select