[jerrold]

please hel me.. Please



i have two table

1) Table1
field name
1) FreeBag = 100
2) BuyBag = 50
the total is 150

2) Table2
field name
1) DeliveredBag = 200

subtract the 200-150 i want the output is 50

this is my code

<table>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "FILEDSN=c:/dsn/MyTable_dsn.dsn"
SQL_query = "SELECT SUM(BuyBag+FreeBag-DeliveredBag)AS Total FROM Table1, Table"



Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<tr>
<td>Total Bag Remain</td>
<td><%=RS("Total")%>&nbsp;</td>
</tr>
<%
RS.MoveNext
WEND
RS.Close
MyConn.Close
%>
</table>

what is the wrong of my code?
Please help me... Thank you..

[job0107]

Well the first thing I see is you have two tables named "Table1" and "Table2".
But in your query string you have "Table1" and "Table".
As long as you only have one entry in your table fields then your query should work fine.
And you don't need the WHILE loop because you are getting only one result.
But if you are trying to use the WHILE loop because you have more than one entry in each table field, then the SUM command will not give you the expected results.
And you will have to SUM each field and do your calculations in your output instead of the query.