microsoft access

  • Thread starter Thread starter AB1
  • Start date Start date
A

AB1

I have a field called the calcel date. It is either blank or have a date in
it. I need to produce a query (which leads to a report) that would exclude
any records that have a cancel date. What should I put into my criteria to
exclude such records?
 
Try criteria of
Is Null



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top