Tracking Non-Empty Data Through Records

[LD Afogel]

Hey All,

I'm by no means a pro at this, so I would appreciate some help finding a solution.

I am creating a database which will contain a sequential set of commands for a group of people. The database needs to be editable.

I think the best way to describe my problem is by example. Say I have 10 records.

In rec2: Field 1 = "ON"

In rec5: Field 1 = "OFF"

In rec8: Field 1 = "ON"

I'd like to make use of conditional formatting so that in rec2 through rec4, a field is bold, then in rec5 through rec7, the field is not bold, and so on and so forth.

I don't know how to make it look back in the sorted list to see what the last non-empty record is.

If you need me to explain it differently, please let me know.

Thanks,

Alex

[Lee Smith]

If I'm understanding you correctly.

Use the Conditional Formatting with a formula of

Self = "ON"

then select the Bold as the Format.

HTH

Lee

[comment]

You could try something like the attached.

Keep in mind that the cascading calculation is unstored, and may prove too slow for large found sets.

Cascade.fp7.zip

[LD Afogel]

That did the trick.

Thanks for the help!

Alex