Yet another crosstab question ...

[Guest]

Hi there,

I would like my Crosstab query to display as column headers each day of a
full week.

Ie: Sun Mon Tue Wed Thu Fri Sat

Now each day may or may not have data in it but I would still like to have a
Column of the specific day.

I have read about changing the property of the column herders in the query
itself but I am obviously missing something as I cannnot get it to work.

Thanks in advance

 

[Guest]

I should add that the weekdays will be dynamic and are being specfied by 2
firelds on a form; a [Start Date] and [End Date] which will always be a full
week that will always start on Sunday. In the table that I am pulling the
data from, the dates are all in Short Date Format.

I finally figured out what was meant by the crosstab queries properties and
putting in the headers but still cannot get it to display each day of the
week in Short Day format.

Thanks in advance

 

[John Spencer]

It would help if you posted the SQL (Text) view of your query. Then someone
could suggest specific modifications to the query. A sample query would
look something like the following.

Parameters [Start Date] DateTime;
TRANSFORM Count(T.fLink) AS CountOffLink
SELECT T.fSubject
FROM YourTableName as T
WHERE T.DateField Between [Start Date] and [Start Date] + 6
GROUP BY T.fSubject
PIVOT Format(T.DateField,"ddd") In
("Sun","Mon","Tues","Wed","Thu","Fri","Sat")

I should add that the weekdays will be dynamic and are being specfied by 2
firelds on a form; a [Start Date] and [End Date] which will always be a
full
week that will always start on Sunday. In the table that I am pulling the
data from, the dates are all in Short Date Format.

I finally figured out what was meant by the crosstab queries properties
and
putting in the headers but still cannot get it to display each day of the
week in Short Day format.

Thanks in advance

Hi there,

I would like my Crosstab query to display as column headers each day of a
full week.

Ie: Sun Mon Tue Wed Thu Fri Sat

Now each day may or may not have data in it but I would still like to
have a
Column of the specific day.

I have read about changing the property of the column herders in the
query
itself but I am obviously missing something as I cannnot get it to work.

Thanks in advance