Another question on fiscal year reports

[Guest]

I have read through all of the threads on how to report in fiscal year, but I
can't seem to make any of them fit my needs. I have never used the modules
or macros in Access (never had the need before) so I don't really know how
they work. I have a db that collects waste generation data from our campus,
by location department and generator. I have many reports that compare
calendar year to year data, but want the data to display in fiscal year (July
1- June 30), to correspond to our budgeting. I tried plugging in the
function suggested by Roger Carlson on 2/8/2005, but I just don't know how to
connect in to my reports. My data starts in July 2000 to the current date.
I want my report to display all fiscal years in one report for each
department.

Thanks for any help in advance.

 

[Alex H]

Pam

I had to do something similar - my year runs August - July

First I created the following module:
AcademicYear = "0"

Dim m As Long
Dim y As Long

m = DatePart("m", MyDate)
y = DatePart("yyyy", MyDate)

If m < 8 Then
AcademicYear = y - 1 & "-" & Right(y, 2)
Else
AcademicYear = y & "-" & Right(y + 1, 2)
End If

then I created a query (in some cases 2) which grouped the date field by
AcademicYear plus the other data required for each report criteria. I had
a total of 18. I then created a report (well there are 4 linked) which
displays the data from the criteria.

Alex

 

[Guest]

Thanks Alex! I didn't do exactly what you did but I did use the code you
supplied. I am still working on it, but you got me going in the right
direction (I think....)

Pam