Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Mon Feb 23 11:25:27 CST 2004
Why is it prompting me for status ?
TRANSFORM Count([Ron Data Mid OP].ID) AS CountOfID
SELECT "Investigation Opened" as [Status], Count([Ron Data Mid OP].ID) AS
Total
FROM [Ron Data Mid OP]
GROUP BY [Status]
PIVOT Format([MS Date Opened],"mmm") In ("Sep","Oct","Nov","Dec");
-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail