Formula problem

  • Thread starter Thread starter JB
  • Start date Start date
J

JB

Trying to count values between two days. When I insert the formula
below, I receive a message saying wrong number of arguments.

=Count(IIf([Days Old]>=3 and [Days Old]<=10))
 
Trying to count values between two days. When I insert the formula
below, I receive a message saying wrong number of arguments.

=Count(IIf([Days Old]>=3 and [Days Old]<=10))
Click to expand...

This is a Queries newsgroup however, your expression is not written as
for a query.
I'll guess it's in a report and [Days Old] is a field in the report's
record source.

Set an unbound control's control source to:
=Sum(IIf([Days Old] >=3 and [Days Old] <=10,1,0))

or..

=Abs(Sum([Days Old] >=3 and [Days Old] <=10))
 
Back
Top