Count

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

Hello

I have a field called [To Gruen]. It includes many dates.
I would like to have a count have a particular range ex. a
count of all records after 6/1/04. Tried the formula
below without success.

=Count([To Gruen]>6/1/4)

Any ideas.

Max
 
MAX said:
I have a field called [To Gruen]. It includes many dates.
I would like to have a count have a particular range ex. a
count of all records after 6/1/04. Tried the formula
below without success.

=Count([To Gruen]>6/1/4)
Click to expand...


Count just counts non-Null values, so your expression will
count all records (a slow version of Count(*)).

Use either one of these instead:

=Count(IIf([To Gruen]>#6/1/2004#, 1, Null))
or
=Abs(Sum([To Gruen]>#6/1/2004#))

where the first is probably easier to understand, but the
latter is faster.
 
Back
Top