Board index Office Access

Change a default year to financial year in crosstab query.

Change a default year to financial year in crosstab query.

Post by John Simo » Sun, 14 Sep 2003 18:26:43


Hi,

I have date wise failure data for 10 years, I have
prepared a Crosstab query and failures are counted
yearwise from January to December for 10 years. MS Access
by default takes year from January - December. However I
need failures per financial year i.e from April to March
every year.

Thankyou.
 
 
 
Top

Change a default year to financial year in crosstab query.

Post by Allen Brow » Sun, 14 Sep 2003 20:16:46

Group on:
Year(DateAdd("m", -3, [MyDateField])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/

 
 
 
Top

1. Efficient query for this year/last year/two years ago

2. Mac shipments lowest in 1.5 years - first year-over-year drop in 5.5 years

3. Mac shipments lowest in 1.5 years - first year-over-year drop in 5.5 years

4. year quarters ===> Financial Year

5. year function and financial years

6. Year Parameter, gives year and previous year (beginner)

7. How can it go sideway year by Year ( TahunPel/Year Servie).

8. Comparing y-t-d average between 2 years for each year without surpassing present year's week

9. How to do a "year-to-date" SQL query where "year" commences in August?

10. Query for current year dates plus December of previous year??

11. Need Help Please With Year-Over-Year Query SQL

12. Need help with query for previous year spend vs. current year

13. Need help with query for previous year spend vs. current year spen

14. Crosstab Query - Group by Month and Year

15. Crosstab query for several years based on weeks/months

All times are UTC
Board index