...

View Full Version : Problems adding the SUM



rparish
12-14-2006, 11:02 PM
I am trying to get the sum of a column (cost) in between 2 certain dates and equal to something (lunch) in another column (team)

Any Ideas of what to do here?





<%
dim firstDate, lastDate
firstDate = Request.Querystring("startdate")
lastDate = Request.Querystring("enddate")

Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("db/login.mdb")
MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & MdbFilePath & ";"
SQL_query2 = "SELECT SUM(cost) AS [RecordSum] FROM expensereport WHERE mydate BETWEEN #" & firstDate & "# AND #" & lastDate & "# and team='lunch'"
Set EX = MyConn.Execute(SQL_query2)
WHILE NOT EX.EOF
%>

nikkiH
12-14-2006, 11:05 PM
Well, you took my idea.
What's wrong with it?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum