Sorting in a query

[CLSkcab]

I have the following code in a query to do a sort:

SELECT Notebook.ID
   , Notebook.[Type]
   , Notebook.[Note Date]
   , Notebook.[Note Time]
   , Notebook.[Contact]
   , Notebook.[Reference]
   , Notebook.[Subject]
   , Notebook.[Note]
   , Notebook.[Documents]
FROM Notebook
ORDER BY Notebook.[Contact];
 

Contact is in a table with the definition of Text (size 50). When executed I it come out like this:

Smith, John
Smith, John
Doe, John
Doe, John
Murphy, Mary

I was expecting it to be:

Doe, John
Doe, John
Murphy, Mary
Smith, John
Smith, John

What am I doing wrong?

[zmbd]

Add ASC the end of line 11 in your SQL script.

SO: ORDER BY Notebook.[Contact];

Becomes: ORDER BY Notebook.[Contact] ASC;

[CLSkcab]

The result has no effect.

[twinnyfo]

CLSkcab,

Is your [Contact] field referring to another table? If htis is so, then your query is sorting on the index, not on the name. In that case, if you want to sort by name, you will have to have a join query and include the actual contact name in that table, and sort on that field.

I hope this makes sense.

[jimatqsi]

CLSkcab,
How are you viewing the result? I mean are you simply running the query and looking at it in Datasheet mode, or are you using the query in a report?

Reports don't pay attention to the query sort order, the sort order must be specified in the report itself.

Jim

[CLSkcab]

Right on. Thank you very much.

[twinnyfo]

So glad we could help in any way. Hope you have a great day!