display on first occurrence of a change in the value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

adgorn - 10 Mar 2008 22:15 GMT

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

Reply to this Message

Al Campagna - 10 Mar 2008 22:55 GMT

adgon,
Use the Hide Duplicates propety set to Yes.
Only the first instance of each value will display.

Signature

hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

> How can I have a report display a text message upon the first occurence of
> a
[quoted text clipped - 9 lines]
> Thanks.
> Alan

Reply to this Message

adgorn - 11 Mar 2008 16:21 GMT

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.

Signature

Alan

> adgon,
> Use the Hide Duplicates propety set to Yes.
[quoted text clipped - 12 lines]
> > Thanks.
> > Alan

Reply to this Message