On Thu, 27 Jan 2005 17:40:30 GMT, Samaba via AccessMonster.com wrote:
I need to create a calculated control which will count the number of cases [caseid] if the [casestatus] is "open" and the [casetype] is "a" for a calendar quarter.
I have been struggling with which formula would work best:
dcount
dsum
sum(iif())
What I have working so far:
=DCount("[caseid]","[qryCaseinfo]","[casetype]='a' AND [casestatus]='open'")
Now I need to work in the Calendar Quarter, and I keep getting stuck. Any assistance - or alternate suggestions would be appreciated.
=DCount("*","[qryCaseinfo]","[casetype]='a' AND [casestatus]='open'
AND DatePart("q",[DateField]=1")
Change the 1 to the quarter number wanted.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.