sort in ascending order

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

Guest

I have a form with cliens' last and first name made from a table not from a
query. I want to view records (the names) in ascending order, instead of ID
(primary key-auto) on the form. How I can do that?
 
I didn't get it. Can you be more specific or in details, I'm sorry I'm green
to Access.
 
Tom,
In design mode for your form, click on Properties. One of the properties is
Order By.
Enter the name of the field(s) you want to sort by.
"LastName, FirstName"
 
thank you Klatuu, it worked

Klatuu said:
Tom,
In design mode for your form, click on Properties. One of the properties is
Order By.
Enter the name of the field(s) you want to sort by.
"LastName, FirstName"
Click to expand...
 
Back
Top