Changing order of records

[tjcinnamon]

I am making a database that requires a list of all the crew people in our company. This list is not sorted by alphabetical order but by order of significance (or frequency of) crew person. This list is rather lengthy and if I add a crew person it can only be added to the bottom of the list. The only way I have been able to do this is by manually resorting and retyping the list. Is there any way to add a row in the middle of a table (like I can in Excel)??

Thanks, Joe

 

[wazz]

not possible.

maybe you know this, but, the order of entry is not (or should not be) relevant. but, once the data is in, you can sort it any way you want.

if you need to see what's in there first, start with a report or a listbox -- something that can show you a large list -- that has already been sorted with a query, then go to a data entry form, make your new entry, then back again to the list or report. when the report or reopens, your new data will be there, sorted the way you want by the query.

 

[tjcinnamon]

I have this list in a combo box, and I want the crewpeople to show up in the order of significance which is something access cannot measure. The only two ways I can think of is to number the people which would still require re-editing if someone else is added or, put spaces in front of them so they are alphabetized in the correct order, (although then I lose th auto complete of the combo box unless someone knows the amount of spaces.) Perhaps this will provide more clarity to indefinitly prove this to be impossible.

Thanks, JOe

 

[RV]

which is something access cannot measure

Neither can Excel as apparently the sorting order in done manually.
And that's your answer, you need to use an indicator telling the significance of a crew member so you can sort by significance.

The only two ways I can think of is to number the people which would still require re-editing if someone else is added or, put spaces in front of them so they are alphabetized in the correct order

Don't even consider to try to use of of these options.

RV

 

[wazz]

o i c now.

try this.

 

[tjcinnamon]

I want to be able to pick the way I want to sort the list ex:

crew person 1
crew person 2
crew person 3

I can do that. I enter them in the table like that. Now say that crew person 4 comes along. The only way I can enter them on the table is

crew person 1
crew person 2
crew person 3
crew person 4

What I want to do is insert 'crew person 4' some where in the middle of the list. In excel I can just insert a row, but in access I have to retype out the whole list.

I hope this provides more clarity, I appreciate the help so far,

Joe

 

[supercharge]

If you're entering data directly into a table, it will be impossible to accomplish what you want. You might want to try entering data thru a form. This will avoid having to go to the end of a table to enter new record. Also, you can mimic a form to look exactly like a table. You can do all kinds of sorting on the form that you'd like.

By the way, what specifies the sorting criteria?

 

[john471]

Sounds like you're having trouble conceptualising the diferences between a spreadsheet and a database table.

May I suggest you read This Thread, in particular the last post entitled "Importanat Lesson".

Then have a look at the thread Wazz referred you to, above.

Regards

John