Member Avatar for wkalo
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

  • 1 Contributor
  • 0 Replies
  • 81 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.