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?
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?
create a year field to identify the year. group by this field.
I already have a date field, but do I enter into the expression somehow?
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
Thank you...What does the '/10' do?
if month > 10 then year +1.
Ok...I understand. Thanks