Yet another crosstab question ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lythandra - 28 Nov 2006 20:54 GMT

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

Reply to this Message

Lythandra - 28 Nov 2006 21:20 GMT

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,
>
[quoted text clipped - 10 lines]
>
> Thanks in advance

Reply to this Message

John Spencer - 29 Nov 2006 14:13 GMT

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
[quoted text clipped - 25 lines]
>>
>> Thanks in advance

Reply to this Message