Using Access 2003
In my table column, some of the fields are null, some of the fields are number, and some of the fields are string
Table.
ID, Value
001
002 N/A
003 01
004
005 N/A
006 02
So on...
I want to order the table by number, string then null values,
Query,
Select ID, Value from table order by value
Expected Output
ID, Values
003 01
006 02
002 N/A
005 N/A
001
004
Need Query Help
Create a new query, and insert the following SQL:
SELECT *
FROM Table1
ORDER BY IsNull([Text2]) DESC , Table1.Text2;
Change the names as appropriate.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With