ChartLit: IIf([test]<>'H',[test],IIf([test2]<>'H',[test2],'H')) in query design view should work (or at least not mess up your expression).
But how did you generate the characters that look like double quotes (but are not)?
Because this also works:
SELECT IIf([test]<>"H",[test],IIf([test2]<>"H",[test2],"H")) as ChartLit from tblTests;
but this does not
IIf([test]<>“H”,[test],IIf([test2]<>“H”,[test2],”H”))
You've got some leaning left/right around the first 2 H's but on the last one lean they lean the same way. The are ascii 147 and 148, not 34
Last edited by Micron; 03-19-2017 at 08:10 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.