Skip to Content
0
Former Member
Jan 10, 2008 at 03:32 PM

Help with formula/condition

28 Views

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!!