Cross tab columns by Week

[WB]

I am needing a cross tab report that lists columns by week. Retail is sold,
and I want to look at how many of a particular product were sold for an
entire week. Every item sold is stored in a transaction that includes the
date. I can get the cross tab to work by showing each column as a day
(date), but instead of having 30 or 31 columns for a month, I would like to
have four. Is this possible?

wb

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

IN the query's SQL view set the PIVOT clause to something like this:

PIVOT DatePart("ww", date_column)

You'll get something like this:

Product 25 26 27 28
--------- --- --- --- ---
Bananas 16 30 4 100

The 25, 26, 27, etc. are the weeks in the year.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQRwC14echKqOuFEgEQJ/tgCgmBbq6kNNs2cawT+T9f1imdf8fpAAoIz1
DN5p+YtFL0zdjfmiGOJbRcSf
=37Ru
-----END PGP SIGNATURE-----