06-22-11, 02:47 #1Registered User
- Join Date
- Mar 2011
Unanswered: VBScript - Database - General - Record Count based on a specific field ID
I have created a table which logs a number of downloads for specific documents:
DownloadID DownloadDate DocumentID
I want to be able to list a count of all the Downloads by documentID
So if DocumentID '3' has had a downloadID record created 3 times it shows 3 and so on. I can get it so I have a total record count but I want to break the count down via DocumentID. Solutions would be greatly appreciated.
06-22-11, 07:48 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
SELECT DownLoad.DocumentID, Count(DownLoad.DownLoadID) AS CC
GROUP BY DownLoad.DocumentID;
CC will hold the count of the DocumnetIDhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON