Crystal Reports formula to Access

  • Thread starter Thread starter lindag
  • Start date Start date
L

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"
 
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")))
 
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.



lindag said:
Any suggestions on how to use this formula in Access?
Click to expand...
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 -
Click to expand...

- Show quoted text -
Click to expand...
 
Back
Top