Sorting two fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a customer table which includes first and last names as fields. I
have a data entry form which lists these people. I want to have it sorted
first by last name and then by first name. It is sorted by last name but not
sorting by first name as well.

Thanks,
 
Make a query of your customer table with surname and firstname as the first 2
columns and sort ascending selected on both columns. Base your form on this
query instead of the base table and your sorting should be as you expect.
 
Back
Top