Count Zero or less

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KAnoe - 30 Mar 2005 11:45 GMT

I have a feild that I would like to count the 0 or less on the form header.
I know that if I would like to count all records it would be count (*). I
dont know what code to put in the ( ). The feild name is net.

Any help would be great. Thanks

Reply to this Message

JaRa - 30 Mar 2005 12:39 GMT

2 examples:

Dcount("*","YourTable")

or

SELECT Count(*) FROM YourTable

So the * is a Blank and will choose the fastest field to perform this
agregate frunction.

- Raoul

> I have a feild that I would like to count the 0 or less on the form header.
> I know that if I would like to count all records it would be count (*). I
> dont know what code to put in the ( ). The feild name is net.
>
> Any help would be great. Thanks

Reply to this Message

KAnoe - 30 Mar 2005 13:19 GMT

Raoul,

I'm feeding the form with a Query "DEP_Vol_Numbers". I have this Query do
the following to give me the net feild.

Net: CDbl(Nz([Total Of DEPInDate],0))-CDbl(Nz([Total Of Loss FY],0))

So if no data is found then I get a 0 or it could be a negitive number. I
would like the text box to cound the 0 or less numbers.

> 2 examples:
>
[quoted text clipped - 14 lines]
> >
> > Any help would be great. Thanks

Reply to this Message

JaRa - 30 Mar 2005 14:03 GMT

this?

SELECT Count(*) FROM Dep_Vol_Numbers WHERE Net<=0

- RAoul

> Raoul,
>
[quoted text clipped - 24 lines]
> > >
> > > Any help would be great. Thanks

Reply to this Message

Ronald W. Roberts - 30 Mar 2005 22:10 GMT

>Raoul,
>
[quoted text clipped - 30 lines]
>>>
>>>

Dim x as integer

x=Dcount("[Net]", "DEP_Vol_Numbers", "[Net] <1")

It makes no difference what you use in the first Parameter. You want to
count the number of records
that contain 0 or less in the Net field.

So, you could do something like:

x=Dcount("[Name of any field in your record]", "DEP_Vol_Numbers", "[Net]
< 1")

Ron

Signature

Ronald W. Roberts
Roberts Communication
rwr@robcom.com

Reply to this Message

Dirk Goldgar - 30 Mar 2005 16:14 GMT

> I have a feild that I would like to count the 0 or less on the form
> header. I know that if I would like to count all records it would be
> count (*). I dont know what code to put in the ( ). The feild name is
> net.
>
> Any help would be great. Thanks

So [Net] is a field in the form's recordsource, and you want a text box
in the form header that counts the number of records for which [Net] is
<= 0? Try this as a controlsource expression for the text box:

=Abs(Sum([Net] <= 0))

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

JaRa - 30 Mar 2005 17:45 GMT

Nice one Dirk :-)

- Raoul

> > I have a feild that I would like to count the 0 or less on the form
> > header. I know that if I would like to count all records it would be
[quoted text clipped - 8 lines]
>
> =Abs(Sum([Net] <= 0))

Reply to this Message

Dirk Goldgar - 30 Mar 2005 17:51 GMT

> Nice one Dirk :-)
>
> - Raoul

Thanks, Raoul. I don't remember who I stole that from. Someone in the
newsgroups, I'm sure.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message