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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting by Last Name and then First Name in the Same Field 2
Splitting a Field 1
Windows 10 How to sort an index created in Word 2013 0
Query does not return First or Last record from subquery 1
Total appointments per agent 2
Access MSACCESS - Sorting report based on field calculated in the report 0
Sort syntax for multiplie IIF 2
Sorting 0

Back
Top