MS Access 2002
SQL = "Select * from DomainsAndIPs Order By Service_Name ASC"
I used the following query to sort results ascending, however in some records the Service_Name field is empty and those show up first. Is there a way to still sort alphabetically but have the records with the empty fields show up last?
I then used this:
SQL = "Select * from DomainsAndIPs Order By Service_Web_FQDN IIF(IsNull(Service_Web_FQDN), 'ZZZ', Service_Web_FQDN) ASC"
And it produced this:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression 'Service_Web_FQDN IIF(IsNull(Service_Web_FQDN), 'ZZZ', Service_Web_FQDN)'.
/sortable.asp, line 39