You lost me there Duane. Make a new table field?
- MSAccessProfessionals@groups.io
- Message
Re: Sorting and displaying men and women last names and maiden names
Duane, Should I put that expression in the sort section of the query? Russ Hi Russ, You can create a new column in your query (or expression in a Control Source) FullName: [FirstName] & " " + [MaidenName] & " " & [LastName] If maiden name is null then there will still be only one space between first and last names. Regards, Duane toggle quoted messageShow quoted text | | That’s how I handle it in all my applications for clients. Works just fine. Ben Sevier Sevier Consulting Group (858) 449-0194 toggle quoted messageShow quoted text | | "Sorting and displaying men and women last names and maiden names"
Yes Duane I have done that but how can I sort them by their original name? You know, sorted by Last name of the men and at the same time sort them by the maiden name while displaying the women by first, maiden, last.
Russ | | Hi Russ, Please keep the previous messages from the thread in your reply. You can sort by this expression: Nz([Maiden Name],[Last Name]) Duane toggle quoted messageShow quoted text | | Duane, I will give it a try. Thank you. Russ Hi Russ, You can create a new column in your query (or expression in a Control Source) FullName: [FirstName] & " " + [MaidenName] & " " & [LastName] If maiden name is null then there will still be only one space between first and last names. | |
_._,_._,_
Groups.io Links:
You receive all messages sent to this group.
View/Reply Online (#115593) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]
_._,_._,_
Tidak ada komentar:
Posting Komentar