[AccessD] another Transform query question

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





More information about the AccessD mailing list