Search results

Hello, I have a table and query that will not sort correctly. I would like to sort the field [JOB#] in descending order and there are 7 records that always move up to the top. I have included many screen shots to show what is happening. Below is the Table and Query Below is the query...