display on first occurrence of a change in the value

  • Thread starter Thread starter adgorn
  • Start date Start date
A

adgorn

How can I have a report display a text message upon the first occurence of a
change in the value of a field in the underlying table? In other words, the
field in this table has the same value for many records in a row, but all of
a sudden that can change and I want to alert the report reader once that
subsequent records are now reflecting these changed values. What I think I
need is some kind of switch that changes from say 0 to 1 when that first
change happens.
Thanks.
Alan
 
Doesn't work in this case since I am using IIF as the control source. What I
want is IIF record=0, don't print anything; IIF record=1, print my text
warning, but just the first time.
 
Back
Top