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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to select based on a null date/time value

Status
Not open for further replies.
JSeidel

JSeidel

Technical User
Jan 10, 2003
77
0
0
US
I need to select records where there are null date/time but every formula I use gives me an error...is there some way I can get only those records with null date/time values??
 
Sort by date Sort by votes
Hi
try
isnull({your date field})

cheers

pgtek
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Question
Using "OR" to select data
Replies
4
Views
174
mmck1964
mmck1964
D
  • Question
Running total from a subreport only showing last value
Replies
2
Views
167
hilfy
hilfy
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
136
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Select Top 2 rows where field = 2,3,4 and 5
Replies
1
Views
81
Cpreston
Cpreston
POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
101
POrlowski
POrlowski

Part and Inventory Search

Sponsor

Back
Top