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

On 10 jan, 09:45, ant1983 <ant1...@discussions.microsoft.com> wrote:
> 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