Help with sorting

[Yvonne]

I have this combo box which gets its data from:-

SELECT customer.custom er_id, (nz(customer.fi rst_name,'')+'
'+nz(customer.m iddle_name,'')+ ' '+nz(customer.l ast_name,'')) AS name
FROM customer;

Question is how can this be modified so that it is sorted
alphabetically by last_name

Thanks

Yvonne

[pietlinden@hotmail.com]

Re: Help with sorting


Yvonne wrote:

I have this combo box which gets its data from:-
>
SELECT customer.custom er_id, (nz(customer.fi rst_name,'')+'
'+nz(customer.m iddle_name,'')+ ' '+nz(customer.l ast_name,'')) AS name
FROM customer;
>
Question is how can this be modified so that it is sorted
alphabetically by last_name
>
Thanks
>
Yvonne

just tack the "ORDER BY customer.last_n ame" clause at the end...

[Yvonne]

Re: Help with sorting

just tack the "ORDER BY customer.last_n ame" clause at the end...

Magic, many thanks.

Yvonne