Conditional Reporting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DDrowe - 17 May 2005 18:27 GMT

I want to generate a report that show only items that have not been closed
out. There is a field in which a date is entered if the item is closed. If
there is no date then it is not closed. How do I go about generating a
report that shows only the entries without this date?

Thanks

Reply to this Message

Klatuu - 17 May 2005 18:21 GMT

There are two properties in the report that will get this done for you. Open
your report in design mode. Click on Properties on the tool bar. Look for
the properties Filter: and Filteron:
In the Filter property put "[CloseDate] = Null"
In the Filteron property select Yes
This assumes you are using the table or a query built on the table that has
the data you want to report that includes the field where the close date is.

> I want to generate a report that show only items that have not been closed
> out. There is a field in which a date is entered if the item is closed. If
> there is no date then it is not closed. How do I go about generating a
> report that shows only the entries without this date?
>
> Thanks

Reply to this Message