Crosstab Query Buckets

[KAT1162]

How do I add weekly buckets to a crosstab query? The wizard only has monthly and quarterly. Does anyone know the correct expression for this?

Thanks!

 

[kicker]

KAT could you give some more specific information about your problem.

I didnt get it.


Probably the date filtering may solve your problem, but anyway you should give more infos.

ThnX

 

[KAT1162]

Thanks for your response. For instance, I use the query wizard to create a new crosstab query. The table I am using for the crosstab query contains many records including quantities and dates for each record. The wizard asks which interval I want to group the dates by and gives me these choices: year, quarter, month, date, date/time. Usually I select months, but I would really like the totals to be by weeks. If the wizard does not offer this option, I'd like to know the correct expression so I can total by weeks using the expression.

 

[Alansidman]

KAT
Look at this tutorial. I think it will give you some options on your issue.
http://www.datapigtechnologies.com/flashfiles/crosstab.html
Alan

 

[KAT1162]

I'll try it, thanks!