Calculated Control using 3 criteria including dates

Samaba via AccessMonster.com

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

Nov 13 '05 #1

fredg

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.

Nov 13 '05 #2

Samaba via AccessMonster.com

Thank you for your quick answer!

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #3