
July 28th, 2004, 01:19 PM
|
|
Contributing User
|
|
Join Date: Jun 2004
Posts: 199
Time spent in forums: 1 Day 7 h 17 m 37 sec
Reputation Power: 5
|
|
|
Returning text after a specific value with restrictions
Dear All:
I have created a MS Access form based on a query. In a field called "Honors", it returns text based on gpa(From another field) 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 
|