[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;
>