[MS_AccessPros] DCOUNT For a Fiscal year.

 

I have the DCOUNT statement that brings back a count from 01/01/13 to 12/31/13:

=DCount("ApplicationID","qryWaitingListCurrentMonth"," StatusDate
Between DateSerial(Year(Date()),1,1) and DateSerial(Year(Date()),12,3)

This works right as is as far returning the count but it actually needs to bring back the count from 10/01/12 to 09/30/13 which is our fiscal year.

This is the query that supports it:

SELECT tblApplicationStatus.StatusDate, tlkpApplicationStatusType.ApplicationStatusTypeName, tblApplicationStatus.ApplicationID
FROM tblApplicationStatus INNER JOIN tlkpApplicationStatusType ON tblApplicationStatus.ApplicationStatusTypeID = tlkpApplicationStatusType.ApplicationStatusTypeID
WHERE (((tblApplicationStatus.ApplicationStatusTypeID)=3));

Any ideas how I can achieve this?

Thanks you,

Arthur Lorenzini
Sioux Falls,SD

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2
• New Links 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___