Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab Query (03)

    I have a Crosstab query which itemizes costs by calendar year. Is it possible to change it so that it reports on a fiscal year? Such as September 2006 to August 2005 and etc..

    Example on calendar year:
    <table border=1><td>Cost</td><td>2005</td><td>2006</td><td>2007</td><td>Item_01</td><td>100</td><td>200</td><td>300</td><td>Item_02</td><td>10</td><td>20</td><td>30</td></table>

    Your advice is appreciated.
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Crosstab Query (03)

    Assuming that September - December 2006 belong to the fiscal year 2007, you can add a calculated field to the query

    FiscalYear: Year(DateAdd("m", 4, [DateField]))

    where DateField is the name of your date field, and use this as column header.

Posting Permissions

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