Generating reports by incomplete field

[mathonix]

I am going to be generating a report from one table with the following fields:

DateRequested
DateCompleted
CMName
PatientName

I want the report to only grab information from lines where there there is nothing entered for datecompleted. We need to track which staff are not finishing their reports. Easy way to do this? Thanks in advance for help!

[ConneXionLost]

Hi mathonics,

Use a query to supply data to your report. In the query, for the field DateCompleted, set the criteria to "Is Null" (but don't use the quotes).

Cheers,

[mathonix]

perfect. thank you much!