Hi all,
A sanity check please? I have the following nested
Query:
Do I need to include the final false condition (to do nothing)? I changed it to insert 'null' on false
But either way when running I get a Compile error. in query expression
Member table:
TermExpired is not a required field.
What am I doing wrong?
A sanity check please? I have the following nested
IIf
query that populates a field depending on a couple conditions. It has worked for ages, but only gets run once a biennial. This morning I got a compile error. Has IIf
syntax changed perhaps? Query:
SQL:
UPDATE Member
SET Member.TermExpired
= IIf( [Member.ExtraOrdinaryExpiry]<Date()
, [Member.ExtraOrdinaryExpiry]
, IIf( [Member.OrdinaryExpiry]<Date()
, [Member.OrdinaryExpiry] ));
Do I need to include the final false condition (to do nothing)? I changed it to insert 'null' on false
SQL:
, [Member.OrdinaryExpiry]
, Null ));
But either way when running I get a Compile error. in query expression
Member table:
TermExpired is not a required field.
What am I doing wrong?