Results 1 to 2 of 2
  1. #1
    vkumar is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2012
    Posts
    30

    Need help in access 2010

    I have two tables Invoice and Payment. I am running a query to get the Invoice balance. Invoice Balance=Invoice table.Invoice Amount-Payment Table.Amount received.


    Some times the same invoice has multiple payments and if I want to show each time when an invoice gets paid, I want the query to show the balance, so second time when the invoice gets paid I need to get the balance from Invoice Balance-Amount received, instead of Invoice Amount-Amount Received. How to do this? . I can aggregate the Amount Received and then do the calculations, but, this way I am not able to show each payment date if an invoice has multiple payments. Please help.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you create an example of your data showing:
    1. What your query is doing now . . . and
    2. What you WANT it to do.
    ?

    Use the 'Go Advanced' - and then you can use the 'Table' option [under the B for bold icon] to display your data.

    The way you have currently explained what you want is difficult to understand.

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

Similar Threads

  1. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  2. Replies: 0
    Last Post: 06-19-2012, 12:39 PM
  3. MS Access 2010 web database and Sharepoint 2010
    By sandeep23 in forum SharePoint
    Replies: 0
    Last Post: 06-05-2012, 11:44 AM
  4. Replies: 1
    Last Post: 01-05-2012, 02:34 PM
  5. Replies: 17
    Last Post: 08-03-2011, 05:19 PM

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