X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Fsvc_acct.cgi;h=fb9ce8aecd9c4f1b7ba0d67128a9c417979508e6;hp=afdc5da471dc026da718f4589f17343637d8fc94;hb=cd6a49deff31eb40300317cb4416a51707378316;hpb=a5d246c0bca64e24b7fd933bed27fc0c99be8c36

diff --git a/httemplate/search/svc_acct.cgi b/httemplate/search/svc_acct.cgi
index afdc5da47..fb9ce8aec 100755
--- a/httemplate/search/svc_acct.cgi
+++ b/httemplate/search/svc_acct.cgi
@@ -35,8 +35,10 @@ sub timelast {
   ";
 
   #Transactions
+#  my $sql = "
+#    SELECT SUM($transactiontime) FROM acct_rt_transaction
   my $sql = "
-    SELECT SUM($transactiontime) FROM acct_rt_transaction
+    SELECT SUM(support) FROM acct_rt_transaction
       LEFT JOIN Transactions
         ON Transactions.Id = acct_rt_transaction.transaction_id
     WHERE svcnum = ?