[AccessD] another CrossTabulation question

beautiful, thank u Gustav.

Now the only thing left is the sorting, which i'll be thinking off now

PARAMETERS [Forms]![Report Form]![Start_Date] DateTime,  [Forms]![Report
Form]![End_Date] DateTime;
TRANSFORM Count([Ron Data spr].[ID]) AS Total
SELECT "Investigation Caseload" AS Status
FROM [Ron Data spr]
WHERE [Preliminary Investigation Opened] is not null
GROUP BY "Investigation Caseload"
PIVOT Format(
IIf([Preliminary Investigation Opened] <
([Forms]![Report Form]![Start_Date]),
DateAdd("d", -1, ([Forms]![Report Form]![Start_Date])),
IIf([Preliminary Investigation Opened] >
([Forms]![Report Form]![End_Date]),
DateAdd("d", 1, ([Forms]![Report Form]![End_Date])),
[Preliminary Investigation Opened])), "mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


> Hi Oleg
>
> This was not clear:
>
> If you wish to include any date outside the interval, just remove the
> year filtering from the WHERE clause so it reads:
>
> WHERE [Preliminary Investigation Opened] Is Not Null
>
> /gustav
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail