Last Modified with an exception

[paulage77]

Not sure if this is possible, but I'd like to define a field for the last modifier. I know how to do this, but I'd like to exclude an individual. That is, to have a field that displays the person who last modified the file, unless that modifier was, say "Bob". Is there anyway to do this? Reason being, there is a script that runs on all records every night from Bob's computer and we don't care about the specific modification.

Thanks in advance!

[paulage77]

I did a better job of searching the forums and got what I believe to be a pretty good solution.

Calculated field:

Case(Left(s_WhoModified,3) != "Bob" , "Last Modified by " & s_WhoModified & " at " & TimeToText(t_Modified) & " on " & DateToText(d_Modified))

-Sorry will do a better job of searching forum before posting next time