<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have the following sql syntax that talks to an access database: -<br />
<br />
rs.Open(&quot;Select NetDelCost, TaxCost, sum(TaxCost + NetDelCost) as 'DeliveryNetttotal' , Sum(NetDelCost) as 'DeliveryGrossTotal' from products WHERE Sold = true &quot;, conn)<br />
<br />
it keeps coming up: -<br />
<br />
You tried to execute a query that does not include the specified expression 'NetDelCost' as part of an aggregate function.<br />
<br />
When I run it in vb.net.<br />
<br />
What am I doing wrong please.<br />
<br />
Many Thanks<br />
Lee<br />

</div>
</div>


Hi,

I have the following sql syntax that talks to an access database: -

rs.Open("Select NetDelCost, TaxCost, sum(TaxCost + NetDelCost) as 'DeliveryNetttotal' , Sum(NetDelCost) as 'DeliveryGrossTotal' from products WHERE Sold = true ", conn)

it keeps coming up: -

You tried to execute a query that does not include the specified expression 'NetDelCost' as part of an aggregate function.

When I run it in vb.net.

What am I doing wrong please.

Many Thanks
Lee


sql syntax error when communicating to an access database in vb.net

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.