dcount with criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jderrig - 28 Oct 2005 15:47 GMT

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

Reply to this Message

Dennis - 28 Oct 2005 16:01 GMT

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
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

jderrig - 28 Oct 2005 16:08 GMT

That works perfectly - THANKS

> Try this
>
[quoted text clipped - 11 lines]
> >
> > Thanks

Reply to this Message

Duane Hookom - 28 Oct 2005 20:22 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message