Two Criteria

[Guest]

I have a query with a criteria set on one filed as "not blank". This gives
me all records that are NOT blank in this field, works great. I also have a
date field and want to set the criteria for it to show all records that do
NOT have a date. I can't get anything to work for this. How do I get all
records with no date on this query? Thanks!

 

[PC Datasheet]

When you put two criteria in the same row you get an "And" combination of
the criteria. Your query is returning all records where the first field is
blank AND the date field is blank. If you put the criteria in different
rows, you get an "Or" combination of the criteria. If you want the query to
return all records where the first field is blank OR the date field is
blank, put the criteria for the first field in the first row and the
criteria for the date field in the second row.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

\