Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Mon Feb 23 09:17:51 CST 2004
Good Morning Group
I have a transform query, and I would like for it to show only the
columns that actually contain data, so if there is no data for September
and October, just show August column followed by November. Is it
possible ?
Thank yo
Oleg
TRANSFORM Count([Ron Data enf].ID) AS CountOfID
SELECT [Ron Data enf].REFERDEPTorSRO AS Origin, Count([Ron Data enf].ID)
AS Total
FROM [Ron Data enf]
WHERE (((IIf([Ron Data enf]![Date Case Ref Received]>=[Forms]![Report
Form]![Start_Date] And [Ron Data enf]![Date Case Ref
Received]<=[Forms]![Report Form]![End_Date],"Cases Closed")) Is Not Null))
GROUP BY [Ron Data enf].REFERDEPTorSRO
PIVOT Format([AMTS Date 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