Thank you for your response

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with number of credits field, which are
numbres (validation rule: >0 And <5) and a field "Letter
Grade", which are capital letters(input mask: >#L) with
validation rule: "A" Or "B" Or "C" Or "D" Or "E" Or "F" Or
"+A" Or "+B" Or "+C" Or "+D" Or "+E" Or "+F" Or "-A" Or
"-B" Or "-C" Or "-D" Or "-E" Or "-F".
I need to create an AutoForm for entering data and
calculating GPA.
My assignment: Points=Number of Credits x Points Value of
Letter Grade. This calculation will require "If" construct.
 
your instructor has given you the calculation
"Points = Number of Credits x Points Value of Letter Grade"
and told you to use an If statement.
open your form in design view and open the Code window.
type the word "if" (without quotes) then press F1. read up
on the If...Then...Else Statement in Help.

hth
 
Back
Top