Trying to filter report in access

  • Thread starter Thread starter spidey3721
  • Start date Start date
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
 
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
 
Back
Top