Filtering Dates on Reports

[cnlsmittle]

I've created a simple suspense query so I can track documents coming in/out of my office. The query contains information such as "Date In," "Suspense Date," and "Date Closed." I need to be able to run a report which only shows me items with an open suspense date. I created a report to run from the query but I can't figure out how to make it show me only items with an open suspense date. Please Help

!!!!

 

[jatfill]

I'm not exactly sure what you mean by "open" Suspense date...

if you mean where there is no Suspense date, the you would use "Is Null" as the criteria on that field (excluding quotes).

If you're looking for something else within the Suspense field, please clarify, I'm sure we can fix it.