Hi
I Have Three Tables
1- Cutomers
2- Payments
3- Invoices
I Need A Way To Build My Qyerry So That I Can Get A Detailed Report On The Customer Account Movement, As Such
Date.........Description.............Cr. Amnt............Db. Amnt..........Balance
And Also The Balance Should Be AddeTo A Previous Balance If It Is Not Zero.
Thkx In Advance