when sorting alphabetically it is wrong

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DTC-PCC - 05 Nov 2005 18:13 GMT

When I run a sort by alphabetically including three feilds it sorts the fist
couple of hundred or so correctly then all of a sudden in the middle of the
sort it is grouping several sections alphabetically whithin the same primary
group. I do not know why it is doing this, it never did it in the past.
Please help if you can?

Reply to this Message

John Marshall, MVP - 05 Nov 2005 18:34 GMT

Can you provide more details? maybe an example of what the mis-sort looks
like.

John... Visio MVP

> When I run a sort by alphabetically including three feilds it sorts the
> fist
[quoted text clipped - 4 lines]
> group. I do not know why it is doing this, it never did it in the past.
> Please help if you can?

Reply to this Message

John Vinson - 05 Nov 2005 20:20 GMT

>When I run a sort by alphabetically including three feilds it sorts the fist
>couple of hundred or so correctly then all of a sudden in the middle of the
>sort it is grouping several sections alphabetically whithin the same primary
>group. I do not know why it is doing this, it never did it in the past.
>Please help if you can?

Please post the SQL of your query.

You might have some damaged indexes in your table - try Compacting the
database; if that doesn't work, open the table in design view; remove
the index on this table; compact the database; recreate the index; and
compact once more.

John W. Vinson[MVP]

Reply to this Message