Results 1 to 7 of 7
  1. #1
    jzacharias is offline Advanced Beginner
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    31

    Year to date sum


    I have text boxes that add up the values from records, but how do I limit the totals on a yearly basis starting from the beginning of October to the end of September?

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    create a year field to identify the year. group by this field.

  3. #3
    jzacharias is offline Advanced Beginner
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    31
    I already have a date field, but do I enter into the expression somehow?

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you need to create a year field which to identity you year, not calendar year, something like:

    MyYear: year([yourdate])+int(month([yourdate])/10)

    you will get 2000 from 1999-10-1 to 2000-9-30
    and 2001 from 2000-10-1 to 2001-9-30

  5. #5
    jzacharias is offline Advanced Beginner
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    31
    Thank you...What does the '/10' do?

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    if month > 10 then year +1.

  7. #7
    jzacharias is offline Advanced Beginner
    Windows Vista Access 2010 (version 14.0)
    Join Date
    Sep 2010
    Posts
    31
    Ok...I understand. Thanks

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

Similar Threads

  1. Use field value as the year in a date
    By Eveline in forum Queries
    Replies: 1
    Last Post: 03-11-2010, 10:58 AM
  2. Date manipulaton for Financial Year
    By Neil Bingham in forum Access
    Replies: 0
    Last Post: 02-15-2009, 11:24 AM
  3. Changing a date to the current year
    By fdnyfish in forum Access
    Replies: 1
    Last Post: 03-01-2008, 08:34 AM
  4. Finding data between two date for any year
    By gemini2 in forum Access
    Replies: 4
    Last Post: 04-05-2006, 06:20 AM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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