Help with crosstab query - when I do a crosstab query, the sum options include quarters and months, but not weeks. How can I do a crosstab query and put my data into weekly buckets? Can I do this via the query wizard or do I need to know what the expression is and type it myself?
