simple "or" formula

[onwiththeshow11]

I have an access database with two fields that contain activated date and terminated date.

In my report, I have a parameter for activation date and the formula is set so if that date is in the activated field or the terminated field it should show on the report.

Whats happening is that if a record has no activated date and only a term date, it is not appearing on the report.

Is there someway to fix this?

Thanks in advance.

 

[Turkbear]

Hi,
In any comparison test in Crystal, you must first test for NULL values - CR stops 'looking' when it finds a NULL, so try one of these - not sure which will work best):

If NOT IsNull({activated_Date}) 
Then
{?Parameter} IN [{activated_Date},{terminated_Date}]
Else
{terminated-Date} = {?Parameter}

Or

Is IsNull {activated_Date} then
{terminated-Date} = {?Parameter}
Else
(
{terminated-Date} = {?Parameter}
OR
{activated_Date} = {?Parameter}
)

To Paraphrase:"The Help you get is proportional to the Help you give.."