Results 1 to 2 of 2
  1. #1
    muhammadirfanghori is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Posts
    6

    Post How To Get Running Balance Of Customer with last balance

    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
    Click image for larger version. 

Name:	Sale Invoice.jpg 
Views:	25 
Size:	119.3 KB 
ID:	26235

    Second I Have Attached Invoice Form Can I Get Invoice Total of subform to main form Total amount
    Attached Thumbnails Attached Thumbnails Sale Invoice.jpg  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the subForm footer, put a textbox,txtSumTotal.
    Set the formula =sum(total)
    then that text box in the master form, Toatal Amt, it can reference the sub box....

    = subForm.form.txtSumTotal

Please reply to this thread with any new information or opinions.

Similar Threads

  1. General Ledger Query With Opening Balance and Running Balance
    By muhammadirfanghori in forum Queries
    Replies: 3
    Last Post: 03-12-2015, 07:17 AM
  2. Replies: 1
    Last Post: 03-29-2014, 10:19 AM
  3. Running Balance in forms or queries
    By Windward in forum Access
    Replies: 7
    Last Post: 02-17-2012, 02:40 PM
  4. Running balance
    By bka57 in forum Forms
    Replies: 3
    Last Post: 01-22-2012, 07:05 PM
  5. Running balance in a form
    By Ray67 in forum Forms
    Replies: 5
    Last Post: 10-24-2011, 07:43 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums