Sort Order Limitation in Queries

[dogman_2000]

Hi

I have a query in access.
I have 1 table in my query and 14 fields in my table.
I am using all 14 fields in my query and have sorted the first 13
fields in Ascending Order.

The problem I am having is this. The first 12 fields are all being
sorted correctly however the 13th field will not sort correclty.
Sometimes its ascending, sometimes descending.
Can anyone tell me if there is a limit to how many fields can be sorted
in a query? I only have 97 rows of data so it's not a huge table.

As a test, I took the data and pasted it in excel and all of it worked
fine!!!

Thanks
Andrew

 

[geebee]

hi,

A couple of things to check...

How long is your query. Sometimes Access truncates the query, resulting in
one or more columns not being sorted in your case.

Is the column not being sorted a MEMO type?

 

[John Spencer]

From Access Help
Query Specifications:
---Sort Limit: 255 characters in one or more fields

I believe that if there are more than that many characters involved in the
sort that only the first 255 are used and the rest are ignored. So, the
sorting could definitely be ignoring the 13th field and might even be
ignoring some of the characters in the 12th field.

 

[dogman_2000]

The problem field which isn't been sorted is a date field.