Auto Field Display

[cmorales]

I'm working on a MS Access database. I need to know how to create a field that outputs a result based on criteria from another field.
Basically I have a field where a grade score will be entered. Based on this value, I want another field to display "Pass" or "Fail".
Your help will be greatly appreciated.

 

[randy700]

Something like....
If me.grade >= 75 Then
me.result = "Pass"
Else
me.result = "Fail"
End If


Randy

 

[cmorales]

Thanks Randy,

I understand the concept of the if statement, however, need to know how to actually create this field. Is this a calculated field. I've attempted to create one to no avail. thanks again.

 

[randy700]

This is output. The field is all ready in your database as a grade score (numerical). There is no reason to also store the "pass/fail" information as it can always be obtained from the numerical data.

I assumed you were looking for a method to indicate "Pass or Fail" on a form or report based on the numerical grade.


Randy