Query Expression !

B

Bob V

If
have a column EmailAlert that contain 0 & -1
can I have an expression if EmailAlert = -1 "e" otherwise Nothing
Thanks for any help..Bob
 
F

fredg

If
have a column EmailAlert that contain 0 & -1
can I have an expression if EmailAlert = -1 "e" otherwise Nothing
Thanks for any help..Bob
Click to expand...

Yes.In a query?
NewColumn:IIf([EmailAlert]=-1,"e","")
 
Top