Table Colum Addition

[LinuxGuy]

How can i get ASP to take a Certain table in an access database, lets say Cost (cost colum and Systematicly
Add the Values together Giving me the Sum on an seperate
page???

 

[Veep]

The SQL will do it:
SELECT sum(cost) as TotalCost FROM myTable

 

[LinuxGuy]

But How do i Implement that into my Code?

SELECT sum(cost) as TotalCost FROM myTable

i want the total Costs to be displayed on the First PAge .
can i email u my Code?

 

[Veep]

<%
strSql=&quot;SELECT sum(cost) as TotalCost FROM myTable&quot;
set conn=server.createobject(&quot;ADODB.CONNECTION&quot
conn.open YourConnectionStringToTheDatabase
set rs=conn.execute(strSql)
If Not rs.eof then
myTotalCost=rs(&quot;TotalCost&quot
ELSE
myTotalCost=0
End IF
set rs=nothing
conn.close
set conn=nothing

response.write(&quot;The Total Cost Is: &quot; & myTotalCost)
%>

 

[LinuxGuy]

Am i going to have to Add the values together iN MS Access and have a total Cost Feild? for SQL to pick up from ??

<%
strSql=&quot;SELECT sum(cost) as TotalCost FROM myTable&quot;
set conn=server.createobject(&quot;ADODB.CONNECTION&quot
conn.open YourConnectionStringToTheDatabase
set rs=conn.execute(strSql)
If Not rs.eof then
myTotalCost=rs(&quot;TotalCost&quot
ELSE
myTotalCost=0
End IF
set rs=nothing
conn.close
set conn=nothing

response.write(&quot;The Total Cost Is: &quot; & myTotalCost)
%>

 

[Tarwn]

No, the sql statement is returning the total of all the values in the &quot;cost&quot; field. You won't need to add another column at all, it's doing the math for you then returning the result as a temporary field called TotalCost.

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/

 

[Veep]

Not based on this example. This SQL does the totaling. You could on the other hand create a query in Access using this SQL statement and use:

strSql=&quot;SELECT TotalCost FROM yourTotalsQuery&quot;

Both ways will work.