Hi All,
I need to create a condition/formula in my query but not sure how to go about it. There is a field "sponsor code" which has values like 0, 20, 54 etc. I need to put in the following condition:
If 'sponsor code' = 0, the records are "federal"
if Sponsor code (not equal to 0), then records are Non-federal.
Can anyone please advice?
Thanks!!