D
Denise
I have a between date field and I want to include all date if the parmeter is
blank. How can I do that?
blank. How can I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marshall Barton
Denise said: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
D
Denise
:
I want to say [enter begin date or press enter for all]
I want to say [enter begin date or press enter for all]
Marshall Barton said:Denise said: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
D
Douglas J. Steele
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.
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
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.
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Denise said::
I want to say [enter begin date or press enter for all]
Marshall Barton said:Denise wrote:
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