Results 1 to 3 of 3
  1. #1
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Cool How to add outstanding balance in next dates, month and year

    dear experts


    i have running total in each row now i want to add running total balance in next days, month and year.

    in below list i have balance in 2013 7 days and i have in 2014 40 days now i want to add 7 days in next year how can i add?

    kindly guide me
    ID LevYear LevStart LevEnd HavingDays LevCnt Balance
    416850 2013

    30 0 30
    416850 2013 1/1/2013 1/10/2013 0 10 19
    416850 2013 2/1/2013 2/3/2013 0 3 16
    416850 2013 2/4/2013 2/4/2013 0 1 29
    416850 2013 2/13/2013 2/21/2013 0 9 7
    416850 2014

    40 0 40
    416850 2014 1/8/2014 1/11/2014 0 4 36

  2. #2
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117
    dear experts have a look on my request i want previous dates balance in next dates what should i do for this.
    if i run current year report of any id and if the same id has balance in last year it should appear as outstanding balance and add in current year.

  3. #3
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117
    dear experts please guide me on priority base.

    highly appreciated for your response.

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

Similar Threads

  1. Year to DATE by Month
    By lugnutmonkey in forum Queries
    Replies: 1
    Last Post: 01-18-2013, 05:37 PM
  2. month year date
    By slimjen in forum Database Design
    Replies: 6
    Last Post: 04-17-2012, 01:02 PM
  3. Sum by Won Project in by each month of the year
    By 011billyw in forum Reports
    Replies: 11
    Last Post: 03-22-2012, 04:09 PM
  4. default month and year
    By beefyalby in forum Forms
    Replies: 3
    Last Post: 12-05-2010, 11:40 PM
  5. by year by month
    By nkuebelbeck in forum Reports
    Replies: 21
    Last Post: 03-24-2010, 01:53 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