Rather use: IIf(IsNull([AccountExpires], Day(Now()),
Day([AccountExpires]))
In most cases, it is a safe bet to use the expression like this for most
fields.
The one that will not work is the Yes/No Type, where you have to
evaluate it to Being either 0 (not selected) or otherwise (-1).
Conrad
-
My piece sent prior to this would probably work better if made as part
of
Your query statement to the database.
Conrad
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 12:55 PM
To: CF-Talk
Subject: Iif, short circuit evaluation and DE
Is
2 matches
Mail list logo
