I have a date field in my query and I want to use a parameter criteria. When I enter [ ] and run the query, it works fine when I enter an actual date. But if I try to enter "Is Null" or "Is Not Null", it doesn't return any records. Without the parameter in criteria, if I enter "Is Null" or "Is Not Null" it works fine. Please tell me what I need to do to make the parameter criteria work with null criteria. Thanks a lot.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Parameter Query
- Thread starter backer
- Start date
tlbroadbent
MIS
Try a query like this.
Select * From TableName
Where DateCol=[Enter the date]
Or IsNull([Enter the date])
I recommend that in the future you post questions about Access queries in the "Microsoft: Access 2 Queries and JET SQL" forum - forum701. This forum is for questions that don't fit in other forums. See thread181-231806 for descriptions of the forums. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Select * From TableName
Where DateCol=[Enter the date]
Or IsNull([Enter the date])
I recommend that in the future you post questions about Access queries in the "Microsoft: Access 2 Queries and JET SQL" forum - forum701. This forum is for questions that don't fit in other forums. See thread181-231806 for descriptions of the forums. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
- Status
Similar threads
- Locked
- Question
