Leftee08
Last Activity: May 3 '13, 03:01 PM
Joined: Apr 24 '13
Location:
-
Thank you so much. It was driving me crazy. I knew it was something small like that. It works great now. -
Trying to change my results in a query using case statement
Hi. I have a fairly simple query and I need to change the name of the results in one field. I have a field called ' Org'. This field has three options. Conasp, Mexico and aspen. I have the following case statement but it won't work.
Case
When org = 'conasp' then ' Utica'
When org = ' aspen' then ' Denver'
When org = ' Mexico' then 'Mexico'
Else ' null'
End
Can someone...
No activity results to display
Leave a comment: