nested IIF BETWEEN AND EXPRESSION

[sichilaba]

Hi,



I have a table called Senior Report Card and this table has the following field names:

Rating1 (data type is short text)
Overral Grade (Unbound text box)
Overall Decision (Data type is short text)

I have created a form based on Senior Report Card Table

On the form l would like to use the IIF Function to calculate the following:

Rating1 is a calculated text box with an IIF function which returns A or B or C or D or E or F or G or H
Overall Grade is a calculated text box with an IIF function which returns A or B or C or D or E or F or G or H

Now l need an expression in Overall Decision that will return Repeat or proceed based on the condition BELOW:

When Rating1 is E or F or G or H AND Overall Grade is A or B or C or D or E or F or G or H THEN Overall Decision should return Repeat otherwise Proceed

I used this expression but its returns the #Name?

=IIF([Rating1] between H and G AND [Overall Grade] between A and H),"Repeat","Proceed")

Help will be appreciated

[CJ_London]

this has already been answered here

https://www.accessforums.net/forms/p...tml#post269743

please don't start new threads when you already have an active one on the same subject