423,851 Members | 2,762 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,851 IT Pros & Developers. It's quick & easy.

Calculated Control using 3 criteria including dates

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
Thank you for your quick answer!

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.