Report DCOUNT

P

Peter Neumaier

Hi,

I got a tabel FOO with myColumn.
I want to DCOUNT all fields in myColumn, in table FOO that are not equal
to 0.

In a report I try this:

=DCOUNT("myColumn","FOO","myColumn <> '0' ")

But I receive allways an error. What#s wrong?

Thx!
 
P

Peter Neumaier

Ken said:
What error do you get? What is the data type of the myColumn field?
Click to expand...
I fixed it:

=DCOUNT("myColumn","FOO","myColumn <> 0 ")

instead of

=DCOUNT("myColumn","FOO","myColumn <> '0' ")


Thx anyway!
 
Top