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.
--
Message posted via http://www.accessmonster.com