Report Criteria Question

[kentwoodjean]

I have a report that where I am trying to capture those projects that have missed their Due Date. The possible Due Date entries on the project log form employees fill out are:

1/1/99 (This represents projects with no end date)
The field is Null (meaning no DD is assigned)
The field has a DD (Could be past or future)

I want to format the Due Date field so it will not show the 1/1/99 entries, Null entries, or future due dates. I only want to see those dates that are past due based on the date of my request. So, if I run the report today, it will only show me those projects with a DD of prior than today.

When I used the criteria, &quot;Is not Null&quot; for my Due Date field, it left me with my past, future due dates, as well as 1/1/1999. I then tried to add OR to my due date criteria using <>#1/1/1999#. Still the 1999 dates are showing. Plus I havn't even begun to tackle how to just get the past dates.

I am just not sure how to do all this. Can anyone help?

 

[kentwoodjean]

Hey everyone, I figured it out myself. Right, wrong or otherwise, I have exactly the result I wanted. Pays not to give up and just keep trying.