Jump to content

Sort records (for list); specific items first


This topic is 2839 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a keys database: what keys have been assigned to a person or location.  so i need a list of these people (scott, bob, smith) or locations (key box 1, key box 2, binder 1).  How can I put the list so that locations are first and people are 2nd (in alphabetical order) like this:

Binder 1
Keybox 1
Keybox 2
Bob
Scott
Smith

Thanks in advance.

Posted

I don't understand your question. These are records in the same table? What fields does this table have? How can one tell the two types apart? 

And what does the "(for list)" part in your title mean?

Posted

Whoops sorry. yes they are all records.  so I have 1 table "Issued List"  it has a "Name" field, which would have the name of the location or name of the person.  

so I create a List based on this table and at the "Name" field.  now I have to get the order correct. that's where I'm stuck.  I have about 10 locations and 100 people.

This topic is 2839 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.