May 16, 20178 yr 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.
May 16, 20178 yr 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?
May 16, 20178 yr Author 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.
Create an account or sign in to comment