Query Expression !

  • Thread starter Thread starter Bob V
  • Start date Start date
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
 
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","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SPAM Filter still spams a safe sender 1
Access Query problem 1
Access #Error & Excel Pivot 0
Data Mismatch in Excel 2010 4
Expressions 7
Append Query 2 4
Access My Expression Contains Wrong number of arguments 0
Query Parameter 4

Back
Top