Report DCOUNT

[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!

 

[Ken Snell [MVP]]

What error do you get? What is the data type of the myColumn field?

 

[Peter Neumaier]

What error do you get? What is the data type of the myColumn field?

I fixed it:

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

instead of

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


Thx anyway!