[AccessD] another CrossTabulation question

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Tue Feb 24 10:32:58 CST 2004


Hi Group

i have a CrossTab query that gives result in  a following order

Jan Feb Mar Apr Jun Jul etc...

4   55  2   12  43  6

If the user selects as dates March 1 to April 31, i'll need to show the
data combining everything before and after -- (the field names don't
matter)

Feb Mar Apr Jun

59  2   12  49

is it possible to do in a crosstab query ?

oleg



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


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





More information about the AccessD mailing list