jeudi 5 mars 2015

How to NOT make a selection if a condition is not met using Microsoft PICT tool?

I want a state such that when FACULTY MEMBER = no, then FISCAL YEAR won't be needed (It will be in OFF state). I have used N/A as a solution but this also means that N/A is an option and thus the PICT tool will give me more results. How do I do something like, IF FACULTY MEMBER = NO, THEN IGNORE FISCAL YEAR?


FACULTY MEMBER: yes, no


FISCAL YEAR: 9, 10, 11, FISCAL YEAR, N/A


IF [FACULTY MEMBER] = "NO" THEN [FISCAL YEAR] = "N/A";


IF [FACULTY MEMBER] = "YES" THEN [FISCAL YEAR] <> "N/A";


Aucun commentaire:

Enregistrer un commentaire