Query

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have two date fields, Entry-1 and Disc-1. I want to
list every record in the database where there are entries
in these two fields for a start date and an end date. I
do not seem to be able to get any of the records when
there is no value in Disc-1. If a student enters our
school for training and is still here at the start date
they will not show up in the query. Any suggestions.
 
I have two date fields, Entry-1 and Disc-1. I want to
list every record in the database where there are entries
in these two fields for a start date and an end date. I
do not seem to be able to get any of the records when
there is no value in Disc-1. If a student enters our
school for training and is still here at the start date
they will not show up in the query. Any suggestions.
Click to expand...

You need to use a criterion such as

([Disc-1] >= [Enter start date:] AND [Disc-1] <= [Enter end date:]) OR
[Disc-1] IS NULL

A NULL value won't match ANY criteria, so you must explicitly check
for NULL.
 
Back
Top