Display a field if another field has more than 1 entry.

I am trying to display the persons name that has been assigned to an order number in a straight table. Some of the names though are blank, so in this case i want to display a Status name instead.

But, some orders have more than one person working on it at different stages, so maybe it is started by one person, but finished by another. In this case i want to display the name of the person who started it.

Does this make sense?

My fields are:

[Operative Name]

[Status Operative]

Stat_StatusID

So i want to do...

If [Operative Name] is null then use [Status Name]. but if Status Name has more than 1 name then use the name assigned to Stat_StatusID = 2 otherwise use Operative Name.

Re: Display a field if another field has more than 1 entry.

Hi, i have attached a sample.

The order showing has no name in it (I have done an expression for the logic behind the names) but on this particular one there are multiple names against the StatusID 2 (Done at different times). so i would like to use the latest status name if no other names are available (As per expression)