Returning text after a specific value with restrictions

[ddennis]

Dear All:

I have created a MS Access form based on a query. In a field called "Honors", it returns text based on gpa and division(The division is Graduate or Undergraduate).

In the excel version of this form, this is the code I used to return the appropriate message:
=IF(I5="Undergraduate",IF(G5>=3.8,"SUMMA CUM LAUDE",IF(G5>=3.5,"MAGNA CUM LAUDE",IF(G5<=3.2,"NONE",IF(G5>=3.2,"CUM LAUDE")))),"")

I would like to use this code, I reckon the VB version of this Excel code to return the appropriate message in the honors field of this MS Access form.

I am the worst programmer on earth, any help is greatly appreciated.

Many thanks in advance,

Dion

 

[Joe4]

In your query, add a calculated field that would look something like:

MyValue:IIF(FieldName1="Undergraduate",IIF(FieldName2>=3.8,"SUMMA CUM LAUDE",IIF(FieldName2>=3.5,"MAGNA CUM LAUDE",IIF(FieldName2<=3.2,"NONE",IIF(FieldName2>=3.2,"CUM LAUDE")))),"")

(essentially, you are simply replacing your cell references with field names and replacing all "IF" with "IIF").

 

[ddennis]

Dear jmiskey:

Many , many thanks.

Dion