If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sort in ascending order
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? |
#2
|
|||
|
|||
Use the Order By property of your form
"Tom" wrote: 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? |
#3
|
|||
|
|||
I didn't get it. Can you be more specific or in details, I'm sorry I'm green
to Access. "Klatuu" wrote: Use the Order By property of your form "Tom" wrote: 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? |
#4
|
|||
|
|||
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" "Tom" wrote: I didn't get it. Can you be more specific or in details, I'm sorry I'm green to Access. "Klatuu" wrote: Use the Order By property of your form "Tom" wrote: 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? |
#5
|
|||
|
|||
thank you Klatuu, it worked
"Klatuu" wrote: 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" "Tom" wrote: I didn't get it. Can you be more specific or in details, I'm sorry I'm green to Access. "Klatuu" wrote: Use the Order By property of your form "Tom" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I have two identical pivot tables with different sort order of th. | WilliamJFoster | General Discussion | 1 | April 7th, 2005 03:48 AM |
Changing sort order in a subform | timlow | Using Forms | 1 | January 5th, 2005 10:04 PM |
Selecting a report's sort order & sort fields at runtime | Alp | Setting Up & Running Reports | 5 | January 2nd, 2005 06:54 AM |
Macro to sort a range in ascending order | Kerrick Sawyers | Worksheet Functions | 1 | February 13th, 2004 02:04 PM |
X Axis Sort Order | Jason | Charts and Charting | 2 | October 9th, 2003 04:12 PM |