Senin, 27 April 2015

Re: [MS_AccessPros] Crosstab Query

 

TRANSFORM Count([Activities & Statuses for Contacts].[ID]) AS CountOfID
SELECT [Activities & Statuses for Contacts].[Contact ID]
FROM [Activities & Statuses for Contacts]
GROUP BY [Activities & Statuses for Contacts].[Contact ID]
PIVOT [Activities & Statuses for Contacts].[Status or Event];

__._,_.___

Posted by: jan.hertzsch@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (15)

.

__,_._,___

Tidak ada komentar:

Posting Komentar