Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple filter-by-date question

Status
Not open for further replies.

Ualale

Programmer
Jun 8, 2002
4
0
0
US
I'm new to Access. Trying to filter by date in a report. I want only records with NO DateShipped. How do I do that and why do all of the following print no records?

[DateShipped]=0/0/00
[DateShipped]<01/01/1990
[DateShipped]=NULL
[DateShipped]=0
 
Try: [DateShipped] Is Null
I would also recommend the help file about Date/time formats
and the chapter about the difference between 0 (zero) and Null values.

You're not alone;

TomCologne
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top