If and Then statement to return a null or blank field value (1 Viewer)

P

Padwan

Registered User.
Local time
Today, 09:12
Joined
Jan 17, 2012
Messages
28
WOOOOOOOOOHOOOOO this did it!!!!!!

CLEARED BY NM1: IIf([REMARKS TX]=True,Null,[CLEARED BY NM])

Thanks for ALL your help :)
 
You must log in or register to reply here.

Similar threads

N
Solved How to encode some field from Json string into the related tables in MS Access
Replies
17
Views
861
nector
N
A
combobox reverting to original value with Not In List event
Replies
15
Views
370
MajP
MajP
N
Solved Storing received Json from the internet into Parent table & child table at one go
2
Replies
21
Views
739
nector
N
C
Invalid Use of Null
2
Replies
20
Views
604
chuckcoleman
C
S
Refine a working regex exclude periods or dots except if a decimal
Replies
10
Views
597
DickyP
DickyP

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom