microsoft access

[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?

 

[John Spencer]

Try criteria of
Is Null



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