|
| 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
May 3rd, 2005, 04:29 PM
|
|||
|
|||
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
May 3rd, 2005, 04:42 PM
|
|||
|
|||
|
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
May 3rd, 2005, 05:15 PM
|
|||
|
|||
|
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
May 3rd, 2005, 06:46 PM
|
|||
|
|||
|
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
May 3rd, 2005, 07:25 PM
|
|||
|
|||
|
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 |
Linear Mode
