 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2005Test for unpopulated Date field
I need to identify a short date field that has not had a date entered into it. Tried creteria ="Nul" but this doesn't work. Try this If isnull(creteria) then End If  SignatureI hope that helped Good luck > I need to identify a short date field that has not had a date entered into it. > Tried creteria ="Nul" but this doesn't work. In the Criteria box, try typing: Is Null or in the actual SQL, try: WHERE (TheDateField Is Null) Regards, Erik >I need to identify a short date field that has not had a date entered into >it. > Tried creteria ="Nul" but this doesn't work. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.