Adding formula to union query

[asmith601]

Hi everyone. I am almost done with my project, but I need help with something. Can someone help with getting the following to work?

SELECT ID as Eval, "Preparation and Punctuality" AS Criteria, I_Q1 AS Grade, =IF([I_Q1]=1,"F","ERROR") AS LETTER_GRADE
FROM issues
UNION SELECT ID, "Subject Knowledge",I_Q2
FROM issues
UNION SELECT ID, "Available to Meet Student Needs",I_Q3
FROM issues;

I have done union queries numerous times before, however I have never tried to incorporate an if statement into one. I would like a formula that can translate number values into letters (1=F, 2=D, 3=C....) into a column. is this possible? Any help is appreciated.

Thanks in advance!

 

[xenou]

A union query MUST have the same number of columns in each part. So your query looks like it won't work (first part has 3 columns, and the other two have only two columns.

At minimum you'd have provide some third values in the last two parts (an empty string, a dummy value such as "n/a", or a Null).

 

[asmith601]

Thank xenou. I see now that I do not have the 3rd column on the other parts now. Thanks for bringing that up. The last item appeared to be using "IF" instead of "IIF". Formula seems to work now. Thanks!