Wow, it's been TOO long since I've released an Access Tip Video. Let's take care of that right now.

Here's a new tip that shows you how to use the SWITCH FUNCTION which is an alternative to using multiple, nested IIF functions. Enjoy.

RR

Access Tip Switch Function Upload Images   Link  David S  7 years ago Should not the default be HDCP>16,"C" rather than just "C"?   The Switch function evaluates each expression in turn and if it evaluates as True then the value that follows that expression is returned.  If more than one expression is True then the value for the first True expression is returned with the others being ignored.  However there must be an expression followed by the return, and in your case there is no expression preceding "C". Read More... Alternatively you can use as the final expression 'True,"C"' (omitting the single quotes).  If none of the expressions evaluate as True then a null value is returned, so to avoid that give a catch all value to a True expression. Reply from Alex Hedley: Yes you need a condition to evaluate Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Tip Switch Function Upload Images   Link  Robert S  7 years ago I tried that and it does not appear to work. Grade:SWITCH(HDCP<=12,"A",HDCP<=16,"B","C") Reply from Alexander Hedley: Do you get a particular error? Does your Table contain a Field named "HDCP" Read More... Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.