Count if Null and If = Yes

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Ive posted this question before and now cant seem to find the it :O

I have a main menu form frmMainMenu and on that for i have a section on
stats and things needing attention.

I want to do a count of all rooms needing venues hence a count of the field
numRoom in table tblTrainingSession - The answer was below which works
perfectly but i want to go one step further and only count as below but for
current training only which is a Yes/No field called blnCurrentTraining. How
do i add this extra bit?

=DCount("*","tblTrainingSession","numRoom Is Null")

Thanks!

ant1983
 
Ive posted this question before and now cant seem to find the it :O

I have a main menu form frmMainMenu and on that for i have a section on
stats and things needing attention.

I want to do a count of all rooms needing venues hence a count of the field
numRoom in table tblTrainingSession - The answer was below which works
perfectly but i want to go one step further and only count as below but for
current training only which is a Yes/No field called blnCurrentTraining.  How
do i add this extra bit?

=DCount("*","tblTrainingSession","numRoom Is Null")

Thanks!

ant1983
Click to expand...

=DCount("*","tblTrainingSession","numRoom Is Null AND
blnCurrentTraining")

Groeten,

Peter
http://access.xps350.com
 
Back
Top