Access Database Query Help

  ihbuk1 14:39 04 Apr 05
Locked

I have two fields - Surname & Christian Name. I have jooined them in a query - Expr1: [Name].[Surname] & " " & [Name].[First Name]and want to display them by Christian Name but sorted by Surname. I can either sort them in Christian name or surname only if Surname is before Ch. Name. Any help / ideas?

Thanks.

  Access Moron 14:47 04 Apr 05

Add the surname to the query as an additional field, sort by this, but dont dispaly the field.

  ihbuk1 14:53 04 Apr 05

Your help is much appreciated, I feel stupid that it was so easy.

This thread is now locked and can not be replied to.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced