Hi,
The table I created has UserName, ClientAccount#, and AccountChangeDate.
My report shows:
User Name AccountChangeDate # of Changes Made
Amy 7/13/2006 449
7/14/2006 582
Total 1031
Ken 7/13/2006 105
7/18/2006 230
Total 335
I would like to add a four column in the report which shows the total # of client accounts each user made changes to on a given date.
I wrote a query:
SELECT [ClientAccountNumber], Count([ClientAccountNumber]) AS [Total # of Client Accounts Edited]
FROM ChangeAudit
GROUP BY [ClientAccountNumber];
I tried to sort the count by date but was unsuccessful...
I will appreciate some advice! Thank you!
The table I created has UserName, ClientAccount#, and AccountChangeDate.
My report shows:
User Name AccountChangeDate # of Changes Made
Amy 7/13/2006 449
7/14/2006 582
Total 1031
Ken 7/13/2006 105
7/18/2006 230
Total 335
I would like to add a four column in the report which shows the total # of client accounts each user made changes to on a given date.
I wrote a query:
SELECT [ClientAccountNumber], Count([ClientAccountNumber]) AS [Total # of Client Accounts Edited]
FROM ChangeAudit
GROUP BY [ClientAccountNumber];
I tried to sort the count by date but was unsuccessful...
I will appreciate some advice! Thank you!
