Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Please help with IIF statement
IIF statements are fairly simple: IIF(condition, value if true, value if false). Here is one option for yours: ComNt: IIf([nt1]=-1 Or [nt2]=-1 Or [nt3]= -1, 1, 0) Another option is to use a nested IIF, where "value if false" becomes a new IIF: ComNt: IIf([nt1]= -1, 1, IIf([nt2]= -1, 1...- tmputman
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Macro in Outlook 2000
There's really no reason to create a macro to add a Signature to selected e-mails. Outlook already has a rather simple method of doing this. Even if you create an Outlook Signature, it does not have to be added to each e-mail message. To turn off the "automatic signature" option, go...- tmputman
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
