Solved

Compound dcount function

Posted on 2012-04-09
3
405 Views
Last Modified: 2012-04-09
I'm trying to use the following code and it bombs out, any suggestions... All I'm trying to do is count the number of records that have a checked box in one column and a null date field in another...Simple right???

Me.fldSA_No_PAA_Date.Value = DCount("[Employee No]", "tblSAARN", "[fldTOA_Privl] = yes" And "IsNull([fldPAA_Date])")

If I try the two conditions individually they both return the proper values but I try and concatenate them into the same dCount function it freaks out????
0
Comment
Question by:rondawg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 37825695
try this

= DCount("[Employee No]", "tblSAARN", "[fldTOA_Privl] = yes And [fldPAA_Date] Is Null")
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 37825700
or this

= DCount("[Employee No]", "tblSAARN", "[fldTOA_Privl] = yes And IsNull([fldPAA_Date])")
0
 

Author Closing Comment

by:rondawg
ID: 37825761
Excellent!!! You are the Bomb!!!
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question