Report - Date Grouping

[paulquinlan100]

Hi

I have a table of investment history ranging over about 10 years, with
the structure:
Inv_Ref
Inv_Type
Inv_date

I need to produce a report where the data is grouped into columns by
Financial year eg

06/07 07/08
08/09
Inv_Type Inv_Date Inv_Type Inv_Date
Inv_Type Inv_Date
Any ideas how i can go about this?

Thanks for any suggestions.
Paul

[Fred Zuckerman]

<pa************@hotmail.comwrote in message
news:11**********************@d34g2000cwd.googlegr oups.com...

Hi

I have a table of investment history ranging over about 10 years, with
the structure:
Inv_Ref
Inv_Type
Inv_date

I need to produce a report where the data is grouped into columns by
Financial year eg

06/07 07/08
08/09
Inv_Type Inv_Date Inv_Type Inv_Date
Inv_Type Inv_Date
Any ideas how i can go about this?

Thanks for any suggestions.
Paul

I would create a user function that takes a date input and creates a string
output of the fiscal year (sample below). Then I would create a query that
adds a new field using that function. Then I would create a 2nd query
(crosstab) to group on that new field.

'''''Sample Function (caution, air code)
Public Function Fiscal (Mdate as Date) as String
' Fiscal Year includes 7/1 thru 6/30
If Format(Mdate,'mmdd') <= 0630 then
Fiscal = "FY" & (Year(Mdate))
Else
Fiscal = "FY & (Year(Mdate) + 1)
Endif
End Function

Fred Zuckerman