dcount with criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Try this

=DCount("[CountOfAccount #]","Grain Accounts","Sales <10000000 And
[Noncompete]='management'")
 
That works perfectly - THANKS

Dennis said:
Try this

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

jderrig said:
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
Click to expand...
Click to expand...
 
Back
Top