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!

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

Check for empty dates 1

Status
Not open for further replies.
CHTHOMAS

CHTHOMAS

Programmer
Jun 16, 1999
106
AE
How to check for empty dates in a date field in a query. I tried using isnull, isempty etc. functions, but of no use. Any ideas or suggestions?

Charley
 
Sort by date Sort by votes
Are you entering "Is Null" or Is Null in the criteria of your query? Try entering just Is Null.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
966
mattKnight
mattKnight
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
519
LondonJohn
LondonJohn
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
409
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Searching for a way to get Access to retrieve and use data from a hard drive file not within Access 3
Replies
13
Views
646
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top