when sorting alphabetically it is wrong

[Guest]

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?

 

[John Marshall, MVP]

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

John... Visio MVP

 

[John Vinson]

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]