Im trying to write an expression. I want it to show FirstName and (MaidenName) in Parenthesis. I only want it to show if the person is a Female denoted by a zero in the Gender field, and the MaidenName field is populated and not empty. Is this possible?
Definitely possible. In fact, I've got a video almost exactly like this coming out shortly. Someone else asked me a similar question a few days ago. Stay tuned.
Thank you Richaed Rost, will keep an eye open for the video, you've just made a good day even better.
Chris WhittinghamOP 2 years ago
After directing me towards your IIF video it now all sorted. A big big thank you Richard.
FullMaidenName: IIf(Not IsNull([MaidenName]),[FirstName] & " (" & [MaidenName] & ")","")
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Genealogy Seminar.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.