why is record 3 at end of report??

[emcf]

I've created a report summarising some of the information on one of my tables - the problem is that record number three insists on appearing as the very last record - all other records are displayed in the order they should be.....what's gone wrong?

 

[Pat Hartman]

If you don't specify a sort order using the report's sorting and grouping options, Access will choose an order for you.