Access SQL ORDER BY putting NULL values last in query

[jacjacjac]

Hello,

NOTE: Im working in MS Access 2003, only results in this SQL/database (not mysyl, MSSQL etc)

I want to be able to ORDER an SQL query and put the NULL values last.

I have a basic databse:
Table name: PeopleTable
Field names: TableID, PersonField, PersonID



The aim is to order by PersonID and put the NULL values last

See pic1.jpg;

The picture (pic1.jpg) shows the database as it is without a query.


See pic2.jpg;

Picture 2 (pic2.jpg) shows the query results when I use the orderby statement (SELECT * FROM PeopleTable ORDER BY PersonID
As you can see it shows the results ordered by the PersonID however the NULL values are first.

See pic3.jpg

Desired results, it is ordered by the PeronID and the NULL values are last (NOTE this is an editied screenshot).
How can i achieve this is MS Access 2003?

Thanks,

Jac

[June7]

Need to handle the Null by converting it to another value that will always sort after the other data. Create another field with expression and use that field to do the sorting, like:

SortID: Nz(PersonID,999999)

or

SortID: Nz(PersonID,"z")