[thelist] MS SS7 - SELECT [computed field] syntax question

[Luther, Ron]

Rudy noted:


>>i think your problem might have been the doublequotes

True, Yeah, thanks!  I found that one pretty early while
experimenting over here.  [MS Query chokes on that and makes
you change it.]


>>also, stay away from IF, use CASE whenever possible

Excellent!!  Thanks!!

I had found the case syntax this morning and got it working for a
single condition.  (Even directly into the row categories in an
Excel pivot table - so that *does* work!)

I was thinking of trying to nest some case statements after lunch.
Mostly because I couldn't find the compound syntax.

>>        , CASE WHEN Field_1 = 'XX'
>>                AND Field_2 = 'YY'
>>               THEN 'New Value'
>>               ELSE Field_3 END     AS New_Field_3


Duh!  Well, Dang.  It always looks simple when you see the right answer, huh?


Thanks Rudy!


Mucho Appreciatavo,
RonL.

(Nope.  I actually bought the 'Grover Park George On Access'
book last year because I have so little experience with Access.
Maybe someday I'll actually read it!)  ;-)