Help setting up a report for "End Date not entered"

J

john doe

I was needing to setup a report for jobs that the "End Date" has not been
entered.
That way I can look at what jobs are still open.
Thanks
 
M

Marshall Barton

john said:
I was needing to setup a report for jobs that the "End Date" has not been
entered.
That way I can look at what jobs are still open.
Click to expand...


Set the report's record source query so that the end date
field has a criteria of Is Null
 
J

john doe

Marshall, I'm sorry. I don't understand what you mean.
I'm kind of new to this.
I created a report by using the report wizard.
I can't seem to find the "reports record source query".
Thanks
 
M

Marshall Barton

Create a new query based on whatever table the report is
currently using. Drag each field down to the query's Field
List. Find the EndDate field and type
Is Null
in the Criteria row under that field.

Open the query to make sure it is providing the desired data
and excluding the data you do not want in the report. When
it's retrieving the right records, save the query with an
appropriate name like OpenJobs or something.

Then open the report in design view. Use the View menu to
see the report's property sheet and locate the Record Source
property. Change the property from the name of the table to
the name of the query you created earlier. Close and save
the report, then preview it to make sure you're getting what
you want.
 
J

john doe

Marshall, that worked great.
Thankyou for your help.
It is appreciated.

Marshall Barton said:
Create a new query based on whatever table the report is
currently using. Drag each field down to the query's Field
List. Find the EndDate field and type
Is Null
in the Criteria row under that field.

Open the query to make sure it is providing the desired data
and excluding the data you do not want in the report. When
it's retrieving the right records, save the query with an
appropriate name like OpenJobs or something.

Then open the report in design view. Use the View menu to
see the report's property sheet and locate the Record Source
property. Change the property from the name of the table to
the name of the query you created earlier. Close and save
the report, then preview it to make sure you're getting what
you want.
--
Marsh
MVP [MS Access]



john said:
Marshall, I'm sorry. I don't understand what you mean.
I'm kind of new to this.
I created a report by using the report wizard.
I can't seem to find the "reports record source query".
Thanks
Click to expand...
Click to expand...
 
Top