help with crosstab query

[Guest]

Hi,

I am constructing a crosstab query using the crosstab wizard and I want to
get customer payments by year. However, I do not want the results displayed
by calander year, rather by billing year. (In this case from 1 July to 30
June).

Can I alter the SQL syntax to reflect the billing year?

thanks,

Pedro

 

[Allen Browne]

Create the crosstab based on the year of the date.

Now where you see:
Year([MyDate])
replace it with
Year(DateAdd("m",-6, [MyDate]))

The column with now show 2005 for all the data between 1 July 2005 to 30
June 2006.