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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Is Null Query - How to?
- Thread starter muddy1
- Start date
Select * from tblWhatever WHERE SomeDateField Is Null
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Thread starter
- #3
- Thread starter
- #4
Hi Jeremy,
Not sure if I am applying this code properly..
I wish to filter all records with [FinishDate] = IsNull from a table [Samples]. When I enter the code "elect * from [Samples] WHERE [DateFinished] Is Null" in the criteria section of DateFinished, I get the following message..
"he syntax of the subquery in this expression is incorrect. Check the subquery's syntax & enclose the subquery in parentheses."
What have I done wrong?
Thanks
Jenny.
Not sure if I am applying this code properly..
I wish to filter all records with [FinishDate] = IsNull from a table [Samples]. When I enter the code "elect * from [Samples] WHERE [DateFinished] Is Null" in the criteria section of DateFinished, I get the following message..
"he syntax of the subquery in this expression is incorrect. Check the subquery's syntax & enclose the subquery in parentheses."
What have I done wrong?
Thanks
Jenny.
select * from [samples] where [datefinished] is null
worked fine in my test database. Try that in a normal query and see if it works.
Where are you using this that it's called a subquery? If it's inside another query, post the full sql here.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
worked fine in my test database. Try that in a normal query and see if it works.
Where are you using this that it's called a subquery? If it's inside another query, post the full sql here.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status
Similar threads
