<div>
it's worked (but i don't has to use the apostrophes<br />
juse like this Winter2011: DSum(&quot;sum&quot;,&quot;invoicesandinv<wbr />oiceszikui<wbr />list1q&quot;,&quot;c<wbr />ustomer=&quot; &amp;&nbsp;[customerid] &amp;&nbsp;&quot; &nbsp;AND orderdate between #09/01/10# AND #03/31/11# &quot;)
</div>


it's worked (but i don't has to use the apostrophes
juse like this Winter2011: DSum("sum","invoicesandinvoiceszikuilist1q","customer=" & [customerid] & "  AND orderdate between #09/01/10# AND #03/31/11# ")

<div>
Ahh okay cool,<br />
<br />
sometimes you need the ' ' depends how the date is stored.<br />
<br />
Glad to help,<br />
Thanks for the grade :)
</div>


Ahh okay cool,

sometimes you need the ' ' depends how the date is stored.

Glad to help,
Thanks for the grade :)

<div>
<div class="content wysiwyg-content">
i wrote this code <br />
Winter2011: DSum(&quot;sum&quot;,&quot;invoicesandinv<wbr />oiceszikui<wbr />list1q&quot;,&quot;c<wbr />ustomer=&quot; &amp;&nbsp;[customerid] &amp;&nbsp;&quot; AND orderdate&gt; #09/01/10# AND &lt;=#03/31/11#&quot;)<br />
<br />
and all the field names are right but when i add this part from &quot;&nbsp;AND orderdate&gt; ,,,, and i run this query the all column written &quot;error&quot; &nbsp;but i can't figure out what is the problem with this
</div>
</div>


i wrote this code 
Winter2011: DSum("sum","invoicesandinvoiceszikuilist1q","customer=" & [customerid] & " AND orderdate> #09/01/10# AND <=#03/31/11#")

and all the field names are right but when i add this part from " AND orderdate> ,,,, and i run this query the all column written "error"  but i can't figure out what is the problem with this

i need help in a query formula in access 2010

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.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.