Query records late to me

[AL Rios]

I need urgent help..

I have two fields in my query. They are :
-Duecor (date field)
-Recdate (date field)

I need to know when the records were sent late. In the query I wrote

In the Recdate critireia I inserted the following:

[Duecor]

and I get those records but I do not the get records that have a Recdate
when it is null and the Duecor date has past.

Please help

Thank you

 

[Marshall Barton]

I have two fields in my query. They are :
-Duecor (date field)
-Recdate (date field)

I need to know when the records were sent late. In the query I wrote

In the Recdate critireia I inserted the following:

[Duecor]

and I get those records but I do not the get records that have a Recdate
when it is null and the Duecor date has past.

Try using:

 

[AL Rios]

I have two fields in my query. They are :
-Duecor (date field)
-Recdate (date field)

I need to know when the records were sent late. In the query I wrote

In the Recdate critireia I inserted the following:

[Duecor]

and I get those records but I do not the get records that have a Recdate
when it is null and the Duecor date has past.

Try using:

>Duecor OR (Is Null And Duecor < Date())

Thank You. Works Great