[AccessD] Sort Blanks to the bottom

Steve:

Without testing, wouldn't I need ORDER BY IsNull DESC to get the nulls on
the bottom?


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Sunday, November 02, 2008 9:54 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sort Blanks to the bottom

Rocky,

A possible further simplification:

SELECT VarietyTBL.VarietyID, VarietyTBL.Class, VarietyTBL.Variety FROM
VarietyTBL ORDER BY IsNull(Class), VarietyTBL.Variety

Regards
Steve


Rocky Smolin at Beach Access Software wrote:
> Andy:
> 
> Very clever!  And works with only minor mods:
> 
> SELECT VarietyTBL.VarietyID, VarietyTBL.Class, VarietyTBL.Variety FROM 
> VarietyTBL ORDER BY IIf(IsNull(Class),2,1), VarietyTBL.Variety;
>  
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com