<div>
Both answers excellent. &nbsp;Thank you.
</div>


<div>
<div class="content wysiwyg-content">
Will my expression at the bottom work? &nbsp;<br />
I am concerned that I need some date operator or function before each of the two dates.<br />
Thank you.<br />
<br />
Tom<br />
<br />
<br />
[ Customer]![Type]=&quot;MassDisc<wbr />ount&quot; And [Transaction Table]![Date] Between &quot;10/01/2008&quot; And &quot;09/30/2011&quot;
</div>
</div>


Will my expression at the bottom work?  
I am concerned that I need some date operator or function before each of the two dates.
Thank you.

Tom


[ Customer]![Type]="MassDiscount" And [Transaction Table]![Date] Between "10/01/2008" And "09/30/2011"

Access Expression - between two dates

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.