[MS_AccessPros] Dcount not working

 

I have the followin expression that uses a dcount function:

=DCount("ApplicantID","qryWaitingListCurrentMonth","ApplicationStatusTypeID = '3' AND StatusDate BETWEEN DateSerial(Year(Date()),Month(Date()),1) and DateSerial(Year(Date()),Month(Date())+1,0)")

It is returning a error.

I think it has to do with this part:

ApplicationStatusTypeID = '3'

Can you give me some advice?

Thanks,

Art Lorenzini
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 4

Visit Your Group

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

.

__,_._,___