Senin, 15 Juni 2020

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

Duane,
When I run the query the result is this:

qDeceased
FullName LastName SortName SchNm
Anne Marie Army Army Army  
Terry Bulger Bulger Bulger  
Don Cosgro Cosgro Cosgro  
Sheila D'Attorro Battey D'Attorro D'Attorro
Debbie Dobbs Stacy Dobbs Dobbs
Russell Drury Drury Drury  
John Duffy Duffy Duffy  
Arlene Dunbar Kasper Dunbar Dunbar
Linda Durant Gresian Durant Durant
Robert Froment Froment Froment  
Eileen Gengel Budzyna Gengel Gengel
Nancy Girouard Rafuse Girouard Girouard
Edna Heinz Heinz Heinz  
John Jordan Jordan Jordan  
Barbara Juaire Doherty Juaire Juaire
John Kennedy Kennedy Kennedy  
Carol Kubiak Beland Kubiak Kubiak
Jim Moran Moran Moran  
Tom Parmenter Parmenter Parmenter  
John Pollinger Pollinger Pollinger  
Jeff Riggs Riggs Riggs  
John Robecki Robecki Robecki  
Mark Tebo Tebo Tebo  
Jay Tidman Tidman Tidman  
Sumner Williams Williams Williams  
Linda Woodward Downer Woodward Woodward


But when I run the report, I get this:
Please see image I've included.
_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

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