'order by' in an sql

[Guest]

I finally wrote union statement in an sql that didn't give me an error
message. However, I wanted to sort by the second field I listed. I used the
line ORDER BY [last name] The query is still sorting by first name. I am
working in XP office professional.

 

[Van T. Dinh]

[last name] must be in the Field list of the first part (left part) of the
Union.

If [last name] is already in the first part, post your SQL String.

 

[onedaywhen]

I finally wrote union statement in an sql that didn't give me an error
message. However, I wanted to sort by the second field I listed. I used the
line ORDER BY [last name] The query is still sorting by first name.

Try using its ordinal position in the SELECT clause e.g.

ORDER BY 2;

Jamie.

--