Why does this happen?

L

l_k

I have a contacts query that has eleven columns -- no sort is on every one.
Birthdate is the first; cleaneddate is the last. On occasion, the query
shows as follows:
Today's Date, which is column 5, then the next four columns; this makes
Birthdate now in column 6.
If I sort any of the columns by ascending or descending, the columns end up
back in order. I usually go back to a no sort, and it comes out correct.
Has anyone seen this problem before?
 
L

l_k

I thought that the order columns appear was the same order you have them in
the query. Is this not the case? Again, it dosen't happen every time I run
the query.
 
J

John Vinson

I have a contacts query that has eleven columns -- no sort is on every one.
Birthdate is the first; cleaneddate is the last. On occasion, the query
shows as follows:
Today's Date, which is column 5, then the next four columns; this makes
Birthdate now in column 6.
Click to expand...

If the *column* order is getting scrambled, you may have a damaged
link to the backend database (assuming it's a split database) or you
may have a corrupt database. Try relinking if it's linked, and in any
case Compact and Repair.

It may be prudent to open this Query in SQL view, copy the SQL to
Notepad, delete the query, compact the database, and paste the SQL
back into a new Query's SQL window.

John W. Vinson[MVP]
 
J

James Hahn

But you have indicated that each column has no sort order on it. At least
that's the way I read your message. If you don't apply a sort order in the
query then you get the order that the system decides, which could be
anything at all, and could change between one query and the next.
--
 
Top