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

It might be easiest to create a column in you report's record source. 

Duane

Sent from my mobile

On Jun 12, 2020, at 6:13 PM, Russ <grizpatch@twc.com> wrote:

Duane,

Should I put that expression in the sort section of the query?

Russ

Duane Hookom 4:24pm   #115583   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

Reply  Like  More

Sevier Consulting Group 4:26pm   #115584   That's how I handle it in all my applications for clients. Works just fine. Ben Sevier Sevier Consulting Group (858) 449-0194 bsevier@...     toggle quoted messageShow quoted text

Reply  Like  More

Russ 5:07pm   #115586   "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

Reply  Like  More

Duane Hookom 5:46pm   #115587   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

Reply  Like  More

Russ 6:32pm   #115588   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

Reply  Like  More

Russ 6:43pm   #115589   Where should I put that expression?  Where in the report? Russ 6:32pm   #115588   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