4
442 Sqn
I have a query that calculates the annual vacation time by
summing the total used in a year by the start date
(StartDate) by year. This was done using the wizard to
generate the query. I was given an initial idea on how to
create a query using the following:
FisYear: Year(DateAdd("m", -3, [SomeDateField]))
But, i've been unable to manipulate the data correctly.
Does this have to be a seperate query or can I modify what
I have and if so, How?
I would like the date to generate the sum total a person
uses during teh year, by the fiscal year.
ie from 01 Apr 'yy' - 31 Mar 'yy'
summing the total used in a year by the start date
(StartDate) by year. This was done using the wizard to
generate the query. I was given an initial idea on how to
create a query using the following:
FisYear: Year(DateAdd("m", -3, [SomeDateField]))
But, i've been unable to manipulate the data correctly.
Does this have to be a seperate query or can I modify what
I have and if so, How?
I would like the date to generate the sum total a person
uses during teh year, by the fiscal year.
ie from 01 Apr 'yy' - 31 Mar 'yy'