help with crosstab query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pedro - 25 Jul 2006 04:34 GMT

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

Reply to this Message

Allen Browne - 25 Jul 2006 04:53 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 7 lines]
>
> Pedro

Reply to this Message