Search results

  1. boesch

    Fiscal Year Query problem

    I changed the properties format to General Number instead of Date and that seems to have resolved the problem. Thanks for the help!:)
  2. boesch

    Fiscal Year Query problem

    Here's my code for the fiscal year Year([ValueDate])-IIf([ValueDate]<DateSerial(Year([ValueDate]),11,1),1,0)+1 AS FYear No matter what date it reads from "ValueDate" it returns 1905 eg 11/01/2000 returns 1905 12/01/2003 returns 1905 When I click in the field of each record the date is...
  3. boesch

    Running Sum resetting each year

    Perfect Just one little character can make a world of difference. Thanks for your help!
  4. boesch

    Running Sum resetting each year

    Trying to calculate a YTD running sum by Month where the cumulative amount resets the next year as below. AYear Amonth SumOfFreight RunTot FDate 1995 1 $2,798.59 $2,798.59 Jan 1995 2 $1,675.06 $4,473.65 Feb 1995 3 $2,165.37 $6,639.02 Mar 1995 4 $1,661.66 $8,300.68 Apr 1995 5...
Back
Top Bottom