Excluding Records

  • Thread starter Thread starter carminio
  • Start date Start date
C

carminio

I have set up two reports which pull information from one
table. I want one report to exclude records where the
CompletionDate field is blank. I want the other report to
exclude records where the CompletionDate field is filled
in. How do I accomplish this? I'm not sure how to set up
queries, etc. Right now, both reports are including all
records. thanks.
 
You need a simple query for each report. Just include all
the table fields in each query and save them as
qryAllDates and QryNoDates. In the criteria row under
date put Is Not Null in one and Is Null in the other. Go
to properties of each report and change the control source
to these two queries.
 
It worked!! Thank you very much.
-----Original Message-----
You need a simple query for each report. Just include all
the table fields in each query and save them as
qryAllDates and QryNoDates. In the criteria row under
date put Is Not Null in one and Is Null in the other. Go
to properties of each report and change the control source
to these two queries.

.
Click to expand...
 
Back
Top