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

Luther, Ron Ron.Luther at hp.com
Fri Jan 25 12:34:07 CST 2008

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,

(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!)  ;-)

More information about the thelist mailing list