Paramater Query Show All if Left Blank

[fenhow]

Hi, I have this in a parameter query. The Query calls the begin date and end date from a form. If the user leaves the fields blank on the form I would like all records to show but cannot figure out how to do it.
Can anyone help?

Between [Forms]![frm_ParameterForm]![txtBeginDate] And [Forms]![frm_ParameterForm]![txtEndDate]

Thanks so much.
Fen

 

[pbaldy]

For dates I'd use Nz() around each, like:

Nz([Forms]![frm_ParameterForm]![txtEndDate], #12/31/2029#)

 

[arnelgp]

Between IIF(Trim([Forms]![frm_ParameterForm]![txtBeginDate] & "")="", yourDateField, [Forms]![frm_ParameterForm]![txtBeginDate]) And IIF(Trim([Forms]![frm_ParameterForm]![txtEndDate] & "")="", yourDateField,
[Forms]![frm_ParameterForm]![txtEndDate])

 

[fenhow]

Thank you, on the Nz with the ,12/31/2029 in it. Can you explain the 12/31/2029?
Fen

 

[pbaldy]

For each textbox, you're substituting dates before/after anything that would exist in the data. For the from date I might use 1/1/1980, but you'd use a date appropriate to your data.