subquery problem (calc perc change)

S

scubadiver

All I want to do is calculate the change from one month to the next. The
[previous month] is returned as blank.

Any ideas?

SELECT E164src.Type, E164src.LiveMonth, E164src.Total,
(SELECT total FROM E164src AS temp WHERE (temp.total=E164src.total-1)) AS
[Previous month]
FROM E164src;
 
Top