Strange effect Count() function

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

I have a report that contains the following field (amongst many others) in
the detail section:

=[eventdate] & " (" & [eventserial] & ")"

and this worked fine until today, when I added the following field to a
section footer:

=Count([eventserial])&" events"

When I did this, although the new field in the section footer gives me the
correct 'count' value, that count value is also displayed in the brackets
after the [eventdate] in the detail section - so for e.g. where there are 35
records displayed, each record is displayed with the number 35 after the
[eventdate] (instead of the actual value of [eventserial]).

Why has the addition of the Count field in the section footer affected
(currupted?) the expression in the detail section - and what can I do about
it?

Hope someone can help.

Many thanks
Leslie Isaacs
 
Perhaps a name conflict. What did you name the new control that Counts the
events? If you named it EventSerial that could be the problem.
 
Hello John

That's it!!
In fact I dragged the [eventserial] field from the field list (then edited
it by adding the Count() finction), so of course it was called
[eventserial] - which the expression in the detail section then picked up!

Many thanks
Les



John Spencer said:
Perhaps a name conflict. What did you name the new control that Counts
the events? If you named it EventSerial that could be the problem.
Leslie Isaacs said:
Hello All

I have a report that contains the following field (amongst many others)
in the detail section:

=[eventdate] & " (" & [eventserial] & ")"

and this worked fine until today, when I added the following field to a
section footer:

=Count([eventserial])&" events"

When I did this, although the new field in the section footer gives me
the correct 'count' value, that count value is also displayed in the
brackets after the [eventdate] in the detail section - so for e.g. where
there are 35 records displayed, each record is displayed with the number
35 after the [eventdate] (instead of the actual value of [eventserial]).

Why has the addition of the Count field in the section footer affected
(currupted?) the expression in the detail section - and what can I do
about it?

Hope someone can help.

Many thanks
Leslie Isaacs
Click to expand...
Click to expand...
 
Back
Top