I was wondering if anybody was having the same problem with Access 2007. There is a problem I have not been able to solve when it comes to queries in 2007. I am using a make table query to build a new table based on the sorted records of another. The sorted field contains the values 1 – 2888 long integer values and there are no duplicate values. I can run the same query 10 times and three of those times it will fail to sort properly.
I have run every diagnostic that Microsoft provides and I have the most current updates and service packs on Microsoft Office. I have restarted the system, compacted and repaired the database, and started new databases and yet the problem persists. Anyone else had this problem?

I don't have Access 2007 (yet) but in general I can tell you that the way the table is sorted will not matter if the query design sorts it another way. Are you saying that the QUERY is not sorting correctly or the TABLE?

If the table, that doesn't matter because people should not be entering the table itself. They should be using a form or report based on the table or query.

If you mean the query is not sorting, are you using it in a report that has sorting and grouping set? If so, those may be overriding the query's sort settings.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

This error does not have anything to do with data entry. I've done simple tests on a couple of machines with Office 2007 installed and the results are close. The test I used is a make table query that pulls data from a table with one field that has integer values in it. They go from 1-3000 with no duplicates. I built 10 different tables with a sort that puts the integers in descending order. When I checked the results, 1 to 3 of those tables were not in order.

I find it of great concern that anywhere between 10% and 30% of the queries run are not giving the proper results. If Access 2007 can’t reliably perform a simple sort, what other glitches are in the software that are harder to discover? I am about to uninstall 2007 and go back to Access 2000. I just wanted to see if anyone else had the problem and knows how to fix it.