Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    NC
    Posts
    3

    Unanswered: Calculate or Display the Accounting Month Access97

    I am working in good old Access 97 here at work. I need access to look at a date field and display what ACCOUNTING MONTH that date falls in.
    Is this possible with Access97?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Calculate or Display the Accounting Month Access97

    Yes but you've got to tell us the logic or criteria for an accounting month.


    Originally posted by thegza4
    I am working in good old Access 97 here at work. I need access to look at a date field and display what ACCOUNTING MONTH that date falls in.
    Is this possible with Access97?

    Thanks

  3. #3
    Join Date
    Nov 2003
    Location
    NC
    Posts
    3

    logic

    The accounting month begins on the Saturday after the last working Friday of previous month. The month ends on the last working Friday.

    So in a less confusing way it ends on the last Friday of every month and the next month begins on that following Saturday.

    I have a actual release dates and target release dates for different SKU's. If the target and the actual are in the same accounting month we get credit for it being on time during that month.

    Thanks

  4. #4
    Join Date
    Nov 2003
    Location
    NC
    Posts
    3
    ttt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •