How to create sql Query..table_Transaction
Ref_No Trn-Date Cust_Code Debit Credit
how to create closing balance,Opening Balance Filter by Cust_Code And Trn_Date

This seems oddly specific. That is, those names would tell me you are working with some legacy system or homework.

But as you may know there are fewer and fewer active VB6 developers every year. If you have a legacy system you want to either learn as much as you can about this very old system or look to outsource the work through Upwork or such.

It's only been a few years but our office ended support and fixes for apps we created back in the 1990s that were in VB6. It mainly was for the reason that development has become much more expensive and clients were not wanting to sign the disclaimers about security and pay for the higher rates. I'm sure there are many on Upwork that will accept your legacy system work.

-> However if you can pare your question down to something small I'll see what I can answer to that.

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.