I'm new to writing if statements and need help with what I believe are two relatively simple questions. I'm trying to build a database that will track my students' GPAs (and other info) and would like the statement to go like this:
If an "A" is entered in the Grade field, then enter a 4 in the corresponding Grade Number field.
Also, if a box is checked (Asking if the student and parent addresses are the same), then copy data from the Student Address field into the Parent Address field automatically. If not, leave blank.
Thanks for your help!