Crystal Reports formula to Access

[lindag]

Any suggestions on how to use this formula in Access?

if not(IsNull({MASTER.JMT_DATE})) then "Post Judgment"else
if (IsNull({MASTER.JMT_DATE})) and not(IsNull({MASTER.SUIT_DATE}))
then "Post Suit, Pre Judgment"else
if (IsNull({MASTER.SUIT_DATE})) and (IsNull({MASTER.JMT_DATE})) then
"Pre Suit"

 

[KARL DEWEY]

Here is a guess --
IIF([MASTER].[JMT_DATE] Is Not Null, "Post Judgment",
IIF([MASTER].[JMT_DATE] Is Null AND [MASTER].[SUIT_DATE] Is Not Null, "Post
Suit, Pre Judgment", IIF([MASTER.SUIT_DATE] Is Null AND [MASTER].[JMT_DATE]
Is Null, "Pre Suit", "Unknown")))

 

[lindag]

Thank you so much, worked perfectly.

Here is a guess --
IIF([MASTER].[JMT_DATE] Is Not Null, "Post Judgment",
IIF([MASTER].[JMT_DATE] Is Null AND [MASTER].[SUIT_DATE] Is Not Null, "Post
Suit, Pre Judgment", IIF([MASTER.SUIT_DATE] Is Null AND [MASTER].[JMT_DATE]
Is Null, "Pre Suit", "Unknown")))

--
Build a little, test a little.

Any suggestions on how to use this formula in Access?

if not(IsNull({MASTER.JMT_DATE})) then "Post Judgment"else
if (IsNull({MASTER.JMT_DATE})) and not(IsNull({MASTER.SUIT_DATE}))
then "Post Suit, Pre Judgment"else
if (IsNull({MASTER.SUIT_DATE})) and (IsNull({MASTER.JMT_DATE})) then
"Pre Suit"
.- Hide quoted text -

- Show quoted text -