Date Query

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
 
L

Les

What indicates whether a record is finished or not? You
should have some criteria set again this field or fields.
 
L

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?

Thanks,
Laura
 
J

John Vinson

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.
 
Top