Crosstab query and Row Heading

  • Thread starter Thread starter Liz Taylor
  • Start date Start date
L

Liz Taylor

Hello,

I'm working on a Crosstab query and need some help.

My Column Headings is an Order Date. At this time it's formated per month:
Expr1: Format([Order_date],"mmm").

I'm wondering if there is a way to format this in a weekly fashion instead.
For instance every Tuesday (whatever date that is). So, for instance if I
was looking at the Order Dates for January 2004, the column headings would
be 01/06, 01/13, 01/20 and 01/27.

Any suggestions are very much appreciated.

Thanks,

Liz

Ps. This is the current SQL statement:
TRANSFORM Sum(qryCrosstab_tblCardinalFisher.Order_Qty) AS [The Value]
SELECT qryCrosstab_tblCardinalFisher.Stock_code,
Sum(qryCrosstab_tblCardinalFisher.Order_Qty) AS [Total Of Order_Qty]
FROM qryCrosstab_tblCardinalFisher
GROUP BY qryCrosstab_tblCardinalFisher.Stock_code
PIVOT Format([Order_date],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
 
To pick only tuedays from your list of dates use

DatePart("w",[Order_date],1) = 3

Once you have a list with only single days, the rest
should be easy
 
Back
Top