Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Specifying custom fiscal quarters (Acc2000)

    I know how Access can group records in a crosstab query by calender quarters (1 Jan thru 31 Dec) but I can't find an easy way to group by a custom fiscal quarter. Our fiscal year is 1 Oct thru 30 Sept. Any ideas? I've looked at the Datepart function but it seems to be used only to set the start of a calender quarter.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specifying custom fiscal quarters (Acc2000)

    Add a column to your query and enter the expesion :
    Quarter : Choose (Month([YourDateField]),2,2,2,3,3,3,4,4,4,1,1,1)
    This suppose that you already have selected the dates from 1Oct thru 30 Sept.
    Francois

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Specifying custom fiscal quarters (Acc2000)

    Thanks, I'll try that (sorry to reply so late, I was out last week).

Posting Permissions

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