JimmyJam
Jan 17th, 2000, 03:01 AM
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
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