If and Then statement to return a null or blank field value

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

J
Solved Vb error on changing the color of a two fields
Replies
10
Views
150
Jomat
J
A
Match two numbers and then update
Replies
10
Views
240
Gasman
Gasman
C
How to return null when summing values that include nulls
Replies
6
Views
233
cheekybuddha
cheekybuddha
brucemc777
Solved Equation: If it isn't an error and it isn't Null yet it has no value, what is it?
2
Replies
30
Views
408
brucemc777
brucemc777
L
Consuming an API to retrieve data and store it in a Microsoft Access table.
Replies
3
Views
311
lbcurrier
L

Users who are viewing this thread

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