query criteria that will include all

[Guest]

I have a between date field and I want to include all date if the parmeter is
blank. How can I do that?

 

[Marshall Barton]

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

 

[Guest]

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

 

[Guest]

:
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.

Check if the parameter is null, maybe something like:

Between [Enter Start Date] And [Enter Start Date]+7 OR
[Enter Start Date] Is Null

 

[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)

:
I want to say [enter begin date or press enter for all]

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