Expression in Form

F

Fiona

I have a form where i need to put in an expression that
counts records that have a zero as their value. What is
the best way of doing this.
 
M

Michael Keating

Hi,

the expression you need to use is

sum( iif( [field] = 0, 1, 0))

typically it is used to create a field in the query that populates the form.


HTH


MFK.
 
G

Guest

Many thanks that worked well. How would i do it for the
opposite to count the the records with a figure greater
than zero as their value.

Thanks.
-----Original Message-----
Hi,

the expression you need to use is

sum( iif( [field] = 0, 1, 0))

typically it is used to create a field in the query that populates the form.


HTH


MFK.

I have a form where i need to put in an expression that
counts records that have a zero as their value. What is
the best way of doing this.
Click to expand...


.
Click to expand...
 
F

fredg

Many thanks that worked well. How would i do it for the
opposite to count the the records with a figure greater
than zero as their value.

Thanks.
-----Original Message-----
Hi,

the expression you need to use is

sum( iif( [field] = 0, 1, 0))

typically it is used to create a field in the query that populates the form.


HTH


MFK.

I have a form where i need to put in an expression that
counts records that have a zero as their value. What is
the best way of doing this.
Click to expand...


.
Click to expand...
Click to expand...

Just change the criteria to >0
 
Top