[AccessD] A2K:CrossTab Question

Hi Darren

What are the periods?

/gustav


> I have a table that records the dates of occurences - so far so good. The table name is tblOffences, the Field is called OffenceDate
> (very original - I know:-)) Date /Time data format Date Format = dd/mm/yyyy
>
> What I need is for the crosstab that is going to display my chart to
> break down all the occurence dates into 'day' groups. IE show all
> the offences throughout the year that fall on a monday into the
> monday group, tuesday occurences into the tuesday group etc.
> I want that bit to be my row heading.
>
> The column heading is to be Periods 1 through to 6.
> This is also captured with the Offence date.
> EG Each record captures Offence date - 1/1/2004, Period1