Kamis, 20 November 2014

[MS_AccessPros] Breaking down by month

 

I have the following query which is pretty basic:


SELECT tblApplication.ApplicationID, tblApplication.AppReceivedDate
FROM tblApplication
WHERE (((tblApplication.AppActiveFlag)=True));


What I need to do is get a count of applications broken down by months for the last 12 months.


Any ideas?


Thank you,

Arthur Lorenzini

Sioux Falls, SD

__._,_.___

Posted by: dbalorenzini@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar