wkalo 0 Newbie Poster

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