SQL problem, database crashes.

  • Thread starter Thread starter scubadiver
  • Start date Start date
S

scubadiver

I am trying calculate percentage from month to month for each client group.

The following query is called "monthbal1"

SELECT LiveMonth.MonthID, Account.ClientGrp, LiveMonth.LiveMonth,
Sum(CurBal.CurBal) AS Total
FROM LiveMonth INNER JOIN (Account INNER JOIN CurBal ON Account.ClientCode =
CurBal.ClientCode) ON LiveMonth.MonthID = CurBal.MonthID
WHERE (((Account.StatusID)=2))
GROUP BY LiveMonth.MonthID, Account.ClientGrp, LiveMonth.LiveMonth
ORDER BY Account.ClientGrp;

Followed by "monthbal2":

SELECT monthbal1.MonthID, monthbal1.ClientGrp, monthbal1.LiveMonth,
monthbal1.Total,

(SELECT Max([Total])
FROM monthbal1 AS temp
WHERE temp.ClientGrp = monthbal1.ClientGrp and
temp.monthID=monthbal1.monthID-1)

FROM monthbal1;


Any idea why the DB is crashing?
 
Back
Top