Trying to filter report in access

S

spidey3721

I have "to do list" table where I mark when items were completed with a
date. I would like to set up a report that shows all items that are
outstanding, but I'm a little new at this. How can I filter completed items
out of the report that I am setting up ?

Thank you
 
T

tina

so, outstanding items don't have a date entered in
that "date" field in the table, correct? if so, do the
following:

create a query based on the "to do list" table.
include in the query all the fields you want to see in the
report.
set the "date" field criteria as "Is Null" (without the
quotation marks).

set the RecordSource property in the report as the query,
not the table.

hth
 
Top