Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Can this Criter...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 30551 of 31576
Post > Topic >>

Can this Criteria be Added to a DCount Expression?

by 6afraidbecause789@[EMAIL PROTECTED] Jun 20, 2008 at 03:23 AM

I was able to glean syntax online for a DCount on a form that counts
the number of 'misbehavior' incidents for students for the current
day:

=DCount("StudentID","Incidents","StudentID=" & Forms!
frmIncidentSummary!StudentID & " and
datediff(""d"",IncidentDateTime,date())=0").

However, there is another field, named IntType, that categorizes the
types of incdents.  How can this additional criteria, for instance,
Forms!frmIncidentSummary!IntType = 1 or IntType = 3 or IntType = 5 be
added into the DCount, counting the number AND types of incidents for
students for the current day?

Where IntType 1 = Hallway, IntType 3 = SRoom, and IntType 5 = Off-
Grounds Suspension

IncTypeID     1     2     3     4     5
IncType     ---     Hallway     SBooth     SRoom     On-Ground     Off-
Ground
IncAbbreviation     HAL     SB     SR     ON     OFF

Therefore, there would be 5 additional columns with 5 DCounts
summarizing this info.  Thanks
 




 7 Posts in Topic:
Can this Criteria be Added to a DCount Expression?
6afraidbecause789@[EMAIL   2008-06-20 03:23:10 
Re: Can this Criteria be Added to a DCount Expression?
Roger <lesperancer@[EM  2008-06-20 03:37:49 
Re: Can this Criteria be Added to a DCount Expression?
6afraidbecause789@[EMAIL   2008-06-20 03:59:15 
Re: Can this Criteria be Added to a DCount Expression?
Roger <lesperancer@[EM  2008-06-20 08:27:53 
Re: Can this Criteria be Added to a DCount Expression?
6afraidbecause789@[EMAIL   2008-06-20 09:35:50 
Re: Can this Criteria be Added to a DCount Expression?
Roger <lesperancer@[EM  2008-06-20 15:20:21 
Re: Can this Criteria be Added to a DCount Expression?
6afraidbecause789@[EMAIL   2008-06-21 05:46:42 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 22:53:53 CST 2008.