Alphabetical sort not working

[emozley]

I have got a query that joins three tables together. One of the columns is a memo field. When I right click on the memo column and click 'Sort Ascending' they do not go into alphabetical order.

Is there any way round this?

I am using MS Access 2002.

Thanks

Ed

 

[emozley]

My apologies should have done a bit more research before posting... in the end I used:

SORT BY Left(DocsCat.DocsCat, 250) ASC

 

[Melagan]

I do believe you can sort by memo fields so I'm not sure what the problem might be. Have you tried sorting in the queries code itself? In query design grid, for your memo field's column, go to the row that says "SORT" and set it to Ascending. What happens then?

~Melagan
______
"It's never too late to become what you might have been.