Senin, 15 Juni 2020

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

Duane, 
I have a list of departed classmates that I would like to sort in alphabetical order using the maiden names and the men's last names.  The maiden name is in the field SchNm abbreviated "School Name".  Their current last name is LastName.
In the report I want to sort the names alphabetically using the SchNm for the married women, and LastNm for the men.  I tried this by duplicating men's last name in the SchNm field, and sorted by SchNm but then in the report the men had the three names like the women did.  Did not work well.

In the report I want the women to be FirstNm SchNm LastNm.  For the men FirstNm LastNm.
Thanks for your help.

Russ


Duane wrote:
"Thanks for posting the SQL view. I don't recall the previous messages so I can't provide much assistance. Which field is the "current last name" and which is the maiden name? How do you want to sort the report?
 
What fields do you want to display in the report?"
 
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

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