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
|
|||
|
|||
Historical Data & re-sorting new data
Hi,
How do I add new drop down box options, re-sort so that it appears at the top of the drop down selection. Will this affect the historical data? -- Lady Chalkley |
#2
|
|||
|
|||
Historical Data & re-sorting new data
On Tue, 16 Jun 2009 19:58:01 -0700, Lady Chalkley
wrote: You're really not providing enough information. Is this a dropdown bound to a query? Have you considered using the NotInList event (see help file) to add new items? Data is sorted using an ORDER BY clause in the underlying query. No, existing data is not affected. -Tom. Microsoft Access MVP Hi, How do I add new drop down box options, re-sort so that it appears at the top of the drop down selection. Will this affect the historical data? |
#3
|
|||
|
|||
Historical Data & re-sorting new data
I think I follow - personnel have departed so they should not be chosen but
still exist so as to display. I add a field, something like Departed (Yes/No) and then use a sort in the select statement like this -- SELECT EmpID, Name, Departed FROM MyTable ORDER BY Departed, Name; This sort the non-Departed first and then by name. I displays the employee status while making selection. "Lady Chalkley" wrote: Hi, How do I add new drop down box options, re-sort so that it appears at the top of the drop down selection. Will this affect the historical data? -- Lady Chalkley |
Thread Tools | |
Display Modes | |
|
|