Can I give Running Balance of Customer
This is my Customer Query
SELECT CustomerDetails.CustomerID, CustomerDetails.[CustomerName], CustomerDetails.[Mobile Number], CustomerDetails.Address
FROM CustomerDetails;
Here is My Payment receipt Query
SELECT [Payment-Receipt].ReceiptID, [Payment-Receipt].CustomerID, [Payment-Receipt].InvoiceDate, [Payment-Receipt].Description, [Payment-Receipt].Amount
FROM [Payment-Receipt];
And This is my Sales Transaction Query
SELECT SaleInvoice.CustomerID, SaleInvoice.InvoiceID, SaleInvoice.InvoiceDate, SalesTransaction.Total
FROM SaleInvoice RIGHT JOIN SalesTransaction ON SaleInvoice.InvoiceID = SalesTransaction.InvoiceID;
Like This This
CustomBlank Data.ziperID Customer Name Debit Credit Balance
1 Irfan 44375 5000 39375
2 Tariq 4625 0 4625
Second I Have Attached Invoice Form Can I Get Invoice Total of subform to main form Total amount