Recent content by mrbrockert

Yes you’re right. I thought about removing the prefix and that is obviously the answer we’re looking for but this would need to be a decision made by my supervisor. But seeing as 3000 is where we’re at after 30 years since the company’s start in 1992, I imagine it will be left the way it is as...

So it appears that every record with Job# under 1000 has a leading space, where these 7 did not. So adding the leading space allowed them to sort properly. I am not sure if this was originally on purpose or happened when converting from MS Works. Thanks for your help! Mark

Yes I have

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...