MSAccess

[Cheanir H via AccessMonster.com]

I have an MSAccess where i have ran a query using expression and the
expression's out come gives me 0 or -1 which are two different statements
each! however i want to change these 0 and -1 to for example 0 to Not and -1
to Due as words? Can anybody help me with this please i really need to get
this done please

thanks

 

[Guest]

Use --
Your Field Label: Iif([YourYesNoField] = -1, "Due","Not")