Date Query

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

My problem is:

I need this query to bring up the data for a date range
that shows me which records that have not been finished in
between those two dates asked.

I have it so it'll ask me for the date range but it shows
all records that were made in between those dates. I only
need the records that haven't been finished yet. Any idea
how I can I "ask" the query to do that?

Thanks,
Laura
 
What indicates whether a record is finished or not? You
should have some criteria set again this field or fields.
 
There is one field called "DateFinished"...if there is no
date in that field than the record is not finished...

How do I get it to show me only the records that aren't
finished?

Thanks,
Laura
 
There is one field called "DateFinished"...if there is no
date in that field than the record is not finished...

How do I get it to show me only the records that aren't
finished?
Click to expand...

Use a criterion of

IS NULL

on Date_Finished.
 
Back
Top