Expression

[Guest]

I have a field called [Verbal Report] that may or may not have date entries.

What expression do I need so that I can create a field in a query that can
be used to show a 1 when this [Verbal Report] is < [Due Date]?

Since [Verbal Report] is left blank 95% of the time I have trouble in trying
to compare against other fields and I get a 1 showing when there is no date
entry for [Verbal Report]

This must be something really simple that I can not think ok.

Brian

 

[John Vinson]

I have a field called [Verbal Report] that may or may not have date entries.

What expression do I need so that I can create a field in a query that can
be used to show a 1 when this [Verbal Report] is < [Due Date]?

Since [Verbal Report] is left blank 95% of the time I have trouble in trying
to compare against other fields and I get a 1 showing when there is no date
entry for [Verbal Report]

This must be something really simple that I can not think ok.

Brian

Use a criterion

< [Due Date] OR IS NULL


or a calculated field:

IIF(NZ([Verbal Report], [Due Date]) < [Due Date], 1, 0)

John W. Vinson[MVP]

 

[Joseph Meehan]

I have a field called [Verbal Report] that may or may not have date
entries.

What expression do I need so that I can create a field in a query
that can be used to show a 1 when this [Verbal Report] is < [Due
Date]?

Since [Verbal Report] is left blank 95% of the time I have trouble in
trying to compare against other fields and I get a 1 showing when
there is no date entry for [Verbal Report]

This must be something really simple that I can not think ok.

Brian

Is the field always null when blank?

Is the field a date type?

Why not exclude records "Where blank" or Where Null" ?