S
Simon
I have a form that is based on a query
The query shows all customer and then lets you seach by customer
surname or first name
It is currently sorted Z to A on surname so it shows customers with
closes matches
If i want to sort by first name it does the search but i sorts by
Surname ( Z to A), what i want it to do is if i search for by
firstname it also sorts firstname by z to A
I want to to sort the list by either last name or first name depending
what i am searchign for
Thanks
SImon
The query shows all customer and then lets you seach by customer
surname or first name
It is currently sorted Z to A on surname so it shows customers with
closes matches
If i want to sort by first name it does the search but i sorts by
Surname ( Z to A), what i want it to do is if i search for by
firstname it also sorts firstname by z to A
I want to to sort the list by either last name or first name depending
what i am searchign for
Thanks
SImon