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
|
|||
|
|||
Sorting Data
Hi
I have created a form where users are able to enter information into the database. However the orginal files in the document are placed in alphabetical order, however when new records are added to the database they are placed at the bottom of the table and are not sorted into the alphabetical structure. I tried going into the physcial table and sorting the records alphabetically but to no avail. What would I need to do to resolve this issue. Thanks |
#2
|
|||
|
|||
Sorting Data
You are confusing how data is stored with how data is displayed. These are
two totally different things. In a relational database (which Access is), data is not stored in any particular order. When the data is displayed it is your responsibility as a database developer to sort it into the sequence you want. If you want a form to display sorted data then base the form on a query of the table with an 'ORDER BY' clause. e.g. SELECT * from MyTable ORDER BY AlphaKey Dorian. "microsoft" wrote: Hi I have created a form where users are able to enter information into the database. However the orginal files in the document are placed in alphabetical order, however when new records are added to the database they are placed at the bottom of the table and are not sorted into the alphabetical structure. I tried going into the physcial table and sorting the records alphabetically but to no avail. What would I need to do to resolve this issue. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
sorting data in linked worksheets | Allyson | General Discussion | 0 | June 8th, 2005 11:25 PM |
multiple docs, one data source | kp | Mailmerge | 12 | January 31st, 2005 04:41 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Sorting blank and non blank column of data | Hari | General Discussion | 1 | July 23rd, 2004 12:13 AM |