Advice For SQL Cross Tab

[JimmyJam]

I need help writing a query. I believe it would be consideed a cross tab query. I have tried using the Access cross tab query Wizard to no avail. I tried writing SQL code but I could not get the result that I wanted. If anyone has done a similar query to what I need to do I would appreciate your help. Thanks

TABLE 1

Account TransDate Amount
139 09/01/99 100
139 09/05/99 250
220 07/01/99 -300
220 07/10/99 -450
139 06/09/99 220
220 03/08/99 -210
220 02/01/99 210
139 10/01/99 -100
139 10/20/99 250
220 11/01/99 -200

Total 139 is 720
Toal 220 is 950


Table 2 Result I am looking For

Account Debit Credit Balance
139 820 100 720
220 210 1160 950

[JimmyJam]

I FIGURED THIS ONE OUT