report auto fill

[spd54]

Hi, Hope someone can help as I can't get my head round this problem. I have a report that fills in a name from one field but if this field is empty I would like to fill from another field so that it is not left blank. Field names are clown name and real name

Thanks



Steve

[NTC]

I would implement this at the record source of the report, not the report itself.
Have a query as the record source if you now only are using a table.
Presuming you have a query - then create a calculated field. So you have your ClownName field then RealName field and then new (calculated) FinalName field with this type syntax:
FinalName: iif(isnull([ClownName]),[RealName],[ClownName])

The IIF method is an if/than using commas so to translate that is: If Clown Name is null then use Real Name otherwise use Clown Name

[spd54]

Thanks will give that a try as I'm using a query to fetch only current members so just need to add that in.

[spd54]

worked a treat thanks again.