Im trying to get a forumal calculated but the problem is that if a student dosent have a SAT score then I must use an ACT score, Also if the student doesn't have Letter Grade point average I must you an hundred point system.

I want for people who use the database to get a popup or something that asks what does the student have; like if the user is at the field for SAT score before they get to fill the field in, I want something that asks did they have an SAT score and if yes they can fill in the field, if no the field can become grey out and there instructed to fill out the ACT Field.) I will probably need to do this for many field. is it possible?

Here's two ways, not made to be efficient, but easier to understand.

First, a calculation, no need to have the user choose:

If ( IsEmpty ( SAT_Score ) ;

If ( IsEmpty ( ACT_Score ) ; // no SAT score see if there's an ACT score

"No Score" ; // no SAT or ACT score

ACT_Score // ACT score only, display

) ;

SAT_Score // SAT score present, display (even if an ACT is present)

)

Assign the popup to a field "ScoreType". Make a calculation with this:

If ( ScoreType = "SAT" ;

SAT_Score ;

If ( ScoreType = "ACT" ;

ACT_Score ;

"Invalid Popup Value"

)

)

Thank you.