Jump to content

Sort records (for list); specific items first


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

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2508 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.