 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / December 2006query criteria that will include all
I have a between date field and I want to include all date if the parmeter is blank. How can I do that? >I have a between date field and I want to include all date if the parmeter is >blank. Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null  SignatureMarsh MVP [MS Access] > >I have a between date field and I want to include all date if the parmeter is > >blank. [quoted text clipped - 3 lines] > Between [Enter Start Date] And [Enter Start Date]+7 OR > [Enter Start Date] Is Null I want to say [enter begin date or press enter for all] > > >I have a between date field and I want to include all date if the parmeter is > > >blank. [quoted text clipped - 3 lines] > > Between [Enter Start Date] And [Enter Start Date]+7 OR > > [Enter Start Date] Is Null Between [enter begin date or press enter for all] And [enter begin date or press enter for all]+7 OR [enter begin date or press enter for all] Is Null Make sure you use exactly the same prompt in all 3 places: it's a good idea to copy and paste, rather than retype. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > I want to say [enter begin date or press enter for all] > [quoted text clipped - 6 lines] >> > Between [Enter Start Date] And [Enter Start Date]+7 OR >> > [Enter Start Date] Is Null |
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.