Why does not the query show last record ?

I have a simple table named students which has been related to a DBGrid
by a Query.
The Sql property of the Query is such as:


Select * From students
Order by Fiels1, Field2, Field3


which Field1, Field2 and  Field3   all are integers fields.
The problem is that DBGrid never shows the last added record. Only when
I add a new record the previous is shown and then the new record is
hidden. It's so strange that when I delete the Order command from the
Query1.Sql then all the records are shown normalle.

Can anyone tell me why this is happening and how I can I solve it ?







4461510_28