K
Kevin Labore
HI
I am attempting to make a crosstab query to have:
the last 12 weeks in sale in cols
the depts in rows
I made a month and some other crosstab queries without a problem
The problem I think is that for example if we are in week 3 for this year I
need the other 9 weeks or such of the previous year
I did try using the criteria with between but that didnt work maybe because
I am using datepart to get the week for the col I tried the below 2 but that
didnt give the results I needed
Between DatePart("ww",Now()) And DateAdd("ww",-13,Now())
Between DateAdd("ww",-1,Now()) And DateAdd("ww",-1,13,Now())
this is the col info for the cross tab query
Weeks: DatePart("ww",[deptdate])
Maybe I should go with with a weekending date?
can someone tell me how to address this?
thanks for any assistance
Kevin
I am attempting to make a crosstab query to have:
the last 12 weeks in sale in cols
the depts in rows
I made a month and some other crosstab queries without a problem
The problem I think is that for example if we are in week 3 for this year I
need the other 9 weeks or such of the previous year
I did try using the criteria with between but that didnt work maybe because
I am using datepart to get the week for the col I tried the below 2 but that
didnt give the results I needed
Between DatePart("ww",Now()) And DateAdd("ww",-13,Now())
Between DateAdd("ww",-1,Now()) And DateAdd("ww",-1,13,Now())
this is the col info for the cross tab query
Weeks: DatePart("ww",[deptdate])
Maybe I should go with with a weekending date?
can someone tell me how to address this?
thanks for any assistance
Kevin