Competent Performer
Windows 10 
Access 2016
Having an issue with sorting hyphenated last names.
Example:
name is added to database as FnamVirgil Smith-Walker
name shows up in reports as Virgil Walker-Smith
lastname field takes the whole "Smith-Walker"
any suggestions how to keep the structure?
thank you.
Competent Performer
Windows 10 Access 2013 32bit
Need more information. Can you please provide the structure of your table holding the data and a few sample records?
VIP
Windows 7 64bit Access 2010 32bit
Why were the last name parts reversed?
If Virgil is in Fname field and Smith-Walker is in Lname field, then the fields can be concatenated to show:
Virgil Smith-Walker
or
Smith-Walker, Virgil
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 7 32bit Access 2007
Kinda fuzzy. If there's a re-ordering going on in the report, this suggests you have more than the first OR last name alone in one report control. So is the name concatenated in a calculated control (but the individual controls are there but perhaps hidden)? Or are they passed to the report as a single field as I think June7 is surmising?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Moderator
Windows 10 Access 2010 32bit
Show us some values in table, and any code manipulation.
Do you process compound last names in some manner?
Query to retrieve last names, it works, except for partial hyphenated names
sorting and grouping not sorting in reports
Posting Permissions
Reply With Quote