G Guest Dec 30, 2006 #1 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. How can I do that?
M Marshall Barton Dec 30, 2006 #2 Denise said: I have a between date field and I want to include all date if the parmeter is blank. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null
Denise said: I have a between date field and I want to include all date if the parmeter is blank. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null
G Guest Dec 30, 2006 #3 Marshall Barton said: Denise said: I have a between date field and I want to include all date if the parmeter is blank. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null Click to expand...
Marshall Barton said: Denise said: I have a between date field and I want to include all date if the parmeter is blank. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null Click to expand...
G Guest Dec 31, 2006 #4 : 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. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null Click to expand... Click to expand...
: 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. Click to expand... Check if the parameter is null, maybe something like: Between [Enter Start Date] And [Enter Start Date]+7 OR [Enter Start Date] Is Null Click to expand... Click to expand...
D Douglas J. Steele Dec 31, 2006 #5 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) 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 Click to expand... Click to expand... Click to expand...
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) 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 Click to expand... Click to expand... Click to expand...
