Expiry Date

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

We are using Access 97.

We use the selection criteria [Expiry Date] < Date() to
find out those expired records.

However, we find that some of the [Expiry Date] fields are
empty (user forget to entry) AND they are not shown in the
Query Result.

We would like to know how to show the expired records even
though it is empty.

Thanks
 
Peter,

Try this expression instead:

[Expiry Date] < Date() Or IsNull([Expiry Date])

HTH,
Nikos
 
I would, in the criteria beneath your first criteria, type in Is Null
so that IF the Expiry Date is Less than todays date OR the field is
Null, show those records...

G2
 
Back
Top