I have a table I use to enter student data and would like my users to
see a student's scholarship amount based on the data they enter into
the following fields:
[FYear/Tsfr] - "First Year" or "Transfer"
[PT/FT] - "part-time" or "full-time"
[HSGPA] - high school GPA on a four point scale (ex. 3.52)
[SATsum] - (ex 1160)
[RSTATUS] - "resident" or "non-resident"
Only full-time students are eligible for a scholarship/award. We have
a scholarship matrix based on the data above, but right now my users
eyeball the correct award amount based on the data they have.
I started to type in an expression, but it was too long. An example or
what I enterred is: IIf([F Year/Tsfr]="First Year" And
[RSTATUS]="resident" And [PT/FT]="full-time" And [HSGPA] Between 3 And
3.24 And [SATsum] Between 800 And 890 Or [ACT Composite] Between 17 And
18,3000). The problem is there are about 50-60 other If statements I
would have to enter.
How else can I display the scholarship/award data besides with an
expression? My knowledge of VB is very basic. Please help.