Filtering in a Query

[VSolano]

Hi all

I need to guide regarding filtering this column in a query.

I have the following column:

BenefitsReconciliationDate: IIf([EndDateValue]=-1,[ReconciliatinDate],[EndDate])

If the value is null, it shows -1 and 0 if is not null

the value for the reconciliation date is the following:

ReconciliatinDate: CStr([TempVars]![recdates])

This field will give me a date

 

[Ranman256]

IIf([EndDateValue],[ReconciliatinDate],[EndDate]) means ENDDATEVALUE is true.
but your instructions say:
IIf(ISNULL([EndDateValue],TRUE,FALSE)

 

[VSolano]

I just need to filter the selection