Timberwolf
Registered User.
- Local time
- Today, 11:50
- Joined
- Dec 15, 2000
- Messages
- 33
In a report I have created a text box in which I'd like the last and first name fields to appear:
=[LastName]+", "+[FirstName]
It works great, unless there is no data in the FirstName field, in which case the report shows no name at all. (A few of our clients are companies, not individuals.)
How can I get the Last Name to show up if there is no First Name?
Thanks.
=[LastName]+", "+[FirstName]
It works great, unless there is no data in the FirstName field, in which case the report shows no name at all. (A few of our clients are companies, not individuals.)
How can I get the Last Name to show up if there is no First Name?
Thanks.