Expression

B

bdehning

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
 
J

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
Click to expand...

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]
 
Top