I've created an update statement in MS Access as follows:
UPDATE myTable SET myDateColumn = IIf(1=1, Null, Now());
which works, setting myDateColumn to Null. If I change the expression in the 'IIf' statement to 1=2 then the column updates to todays date.
I need to re-write this statement for use in a vb.net application.
Can someone provide the correct syntax?