<div>
Confused. &nbsp;What SQL? Excel as topic, VBA as discussion.<br />
<br />
If you executing an SQL query into a dbms such as SQL Server or Oracle please provide the query and we can make recommendations. It might involve using a case expression similar to the IIF shown above e.g.<br />
<br />
order by CASE WHEN x IS NULL THEN 'zzzzzzzzzzz' ELSE x END, ....<br />
<br />
- but there may be other opportunities depending on the query itself and the dbms being used. (e.g. Oracle natively has NULLS First/NULLS Last)<br />
<br />
please indicate dbms vendor and version (if this comment is relevant).
</div>


Confused.  What SQL? Excel as topic, VBA as discussion.

If you executing an SQL query into a dbms such as SQL Server or Oracle please provide the query and we can make recommendations. It might involve using a case expression similar to the IIF shown above e.g.

order by CASE WHEN x IS NULL THEN 'zzzzzzzzzzz' ELSE x END, ....

- but there may be other opportunities depending on the query itself and the dbms being used. (e.g. Oracle natively has NULLS First/NULLS Last)

please indicate dbms vendor and version (if this comment is relevant).

<div>
<div class="content wysiwyg-content">
excel sql vba..<br />
<br />
Is there a way in sql in vba to make nulls go to the bottom of the query instead of the top.<br />
<br />
i found plety of examples but none seem to work?<br />
<br />
for vba...<br />
<br />
How does one use the &quot;SWITCH&quot; clause that includes sql with &quot;where&quot; statements and 3 fields to sort by ?
</div>
</div>


excel sql vba..

Is there a way in sql in vba to make nulls go to the bottom of the query instead of the top.

i found plety of examples but none seem to work?

for vba...

How does one use the "SWITCH" clause that includes sql with "where" statements and 3 fields to sort by ?

sorting and order by with nulls on the bottom after executing query

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.