dcount with criteria

[Guest]

I am trying to get my control source on my report to count the number of
accounts that have sales of Sales <10000000 and have management as a result
in Noncompete. I currently have the following but it does not produce the
correct results. I have tried every variation I can think of but nothing is
working.

=DCount("[CountOfAccount #]","Grain Accounts","Sales <10000000" And
[Noncompete]="management")

Thanks

 

[Guest]

Try this

=DCount("[CountOfAccount #]","Grain Accounts","Sales <10000000 And
[Noncompete]='management'")

 

[Guest]

That works perfectly - THANKS

Try this

=DCount("[CountOfAccount #]","Grain Accounts","Sales <10000000 And
[Noncompete]='management'")

I am trying to get my control source on my report to count the number of
accounts that have sales of Sales <10000000 and have management as a result
in Noncompete. I currently have the following but it does not produce the
correct results. I have tried every variation I can think of but nothing is
working.

=DCount("[CountOfAccount #]","Grain Accounts","Sales <10000000" And
[Noncompete]="management")

Thanks

 

[Duane Hookom]

You might also try:
=Sum(Abs([Sales] <10000000 And [Noncompete]="management") )