Jumat, 12 Juni 2020

Re: [MSAccessProfessionals] Sorting and displaying men and women last names and maiden names

Where should I put that expression?  Where in the report?


6:32pm   

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.

 

Regards,

Duane

 

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

You can sort by this expression:

 

Nz([Maiden Name],[Last Name])

Duane

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115589) | 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