[AccessD] Transform query question

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





More information about the AccessD mailing list