<div>
<a href="https://filedb.experts-exchange.com/incoming/2018/04_w15/1300389/aaaaa.JPG" target="_blank" title="Hi John :) Thanks very much for your help. Has a told before it's the first time I'm using Access, so I don't know if I'm doing things properly. (265 KB)"><img alt="Hi John :) Thanks very much for your help. Has a told before it's the first time I'm using Access, so I don't know if I'm doing things properly." class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/04_w15/800_1300389/aaaaa.JPG" /></a><br />
Hi John :) Thanks very much for your help. Has a told before it's the first time I'm using Access, so I don't know if I'm doing things properly? My aim is to put on the top of the report the sum of all the product codes that start with EVWP and are not excluded.<br />
<br />
Am I doing something wrong?<br />
<br />
Once again, thanks very much :D
</div>


Hi John :) Thanks very much for your help. Has a told before it's the first time I'm using Access, so I don't know if I'm doing things properly.

aaaaa.JPG

Sage Co-ordinator

samuel maia

<div>
I noted that mistake and I amended it. However, it didn't work. But I'm quite sure that's something I did wrong. I'll endeavor to find out whats wrong.<br />
<br />
Thanks very much for your help guys. <br />
<br />
:D
</div>


<div>
<a href="https://filedb.experts-exchange.com/incoming/2018/04_w15/1300423/sa.JPG" target="_blank" title="Statement and Data (391 KB)"><img alt="Statement and Data" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/04_w15/800_1300423/sa.JPG" /></a><br />
Hello again :)<br />
<br />
I've been trying to figure out what I've done wrong. However, I'm having some difficulties.<br />
Here it's a part of my data set and both argument for the functions. <br />
<br />
For instance, in the Dcount, everything it's easy peasy. But when getting down to the nitty-gritty, the Dsum, something goes wrong.<br />
In my data set, in the exclusion column, I've tried both &quot;False&quot; and &quot;No&quot;, but didn't work. <br />
<br />
Any idea about whats wrong?<br />
<br />
Cheers
</div>


sa.JPG

<div>
<a href="https://filedb.experts-exchange.com/incoming/2018/04_w15/1300428/sa.JPG" target="_blank" title="sa.JPG (161 KB)"><img alt="sa.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/04_w15/800_1300428/sa.JPG" /></a><br />
I think its something about the way I was writing the argument. Because now I did the way you can see in the picture and its working (but just for one criteria :( &nbsp; )
</div>


<div>
<div class="content wysiwyg-content">
Hello :)<br />
<br />
I'm having some difficulties in doing this statement .<br />
<br />
Can anyone help me out? It's the first time I'm using access .<br />
<br />
<b>= DSum(&quot;[Quantity]&quot;, &quot;[ MSP]&quot;, &quot;[ ProductCode] LIKE 'EVWP*' AND &quot;[Excluded]&quot;=”FALSE”)</b><br />
<br />
Cheers
</div>
</div>


Hello :)

I'm having some difficulties in doing this statement .

Can anyone help me out? It's the first time I'm using access .

= DSum("[Quantity]", "[ MSP]", "[ ProductCode] LIKE 'EVWP*' AND "[Excluded]"=”FALSE”)

Cheers

Dsum Statement

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.