<div>
<div class="content wysiwyg-content">
I have a form with has two date fields... txtStart and txtEnd. &nbsp;Then I have a query which has this for the criteria... 
 
Between [Forms]![frmSelectDatesForInvestPerfRpt]![txtStart] And [Forms]![frmSelectDatesForInvestPerfRpt]![txtEnd] 
 
But if the user leaves the date fields blank on the form I want the query to return all records. 
 
I tried... 
 
Between &quot;*&quot; &amp;&nbsp;[Forms]![frmSelectDatesForInvestPerfRpt]![txtStart] And [Forms]![frmSelectDatesForInvestPerfRpt]![txtEnd] &amp;&nbsp;&quot;*&quot; 
 
But it doesn't work. 
 
????
</div>
</div>

I have a form with has two date fields... txtStart and txtEnd.  Then I have a query which has this for the criteria...

Between [Forms]![frmSelectDatesForInvestPerfRpt]![txtStart] And [Forms]![frmSelectDatesForInvestPerfRpt]![txtEnd]

But if the user leaves the date fields blank on the form I want the query to return all records.

I tried...

Between "*" & [Forms]![frmSelectDatesForInvestPerfRpt]![txtStart] And [Forms]![frmSelectDatesForInvestPerfRpt]![txtEnd] & "*"

But it doesn't work.

????

How query all records if date fields are left blank on a form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.