Count if Null and If = Yes

[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

 

[XPS350]

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

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

Groeten,

Peter
http://access.xps350.com