set an item on top

[clara]

hi all,

this is the my query:

Select "All Clients" as ClientName from Client
UNION SELECT Client.CLientName
FROM Client

I use the above query as Row Source of a Comb Box and I hope to display "All
CLients" on the top of the selection list of the comb box.

Clara

thank you so much for your help

 

[Jerry Whittle]

SELECT "All Clients" as ClientName,
"A" as SortOrder
FROM Client
UNION ALL
SELECT Client.CLientName,
"B" as SortOrder
FROM Client
ORDER BY SortOrder, ClientName ;

 

[clara]

Hi Jerry,


thank you so much for your help

Clara