List results in my order, not autonumbering etc.

[Guest]

I set up database where for each matter there are several of people involved.
I need to be able to list those people in the order I specify, such as
first, second, third, or like president, vice president, secretary, etc.
There are many matters, each with lists of people.
How can I set this up and create a query to obtain wanted results?

 

[Joseph Meehan]

I set up database where for each matter there are several of people
involved. I need to be able to list those people in the order I
specify, such as first, second, third, or like president, vice
president, secretary, etc. There are many matters, each with lists of
people.
How can I set this up and create a query to obtain wanted results?

You can tell Access to list data in whatever order you want. Of course
you can't do that in a table. Think of the table as just a bucket of data
with no order at all. That's what you have. It may look like it is in
autonumber order, but if you count on that you will soon find out that it
may not work out like that and you will likely find out that autonumbers and
not always in order themselves, they may skip numbers etc.

Use queries, forms and reports to view data. Each of those allows you
to define the order of your choice.

 

[Guest]

Thanks. I don't know if you can explain this to me in words. I have an
invention table with a unique App number for each. There are six inventors.
I have an Inventor table. Of course, the inventors want their names listed
in order of importance, biggest guy first. So one would be Inv1, next Inv2,
etc. There are many inventions and many inventors. How do you link them?
Or query them?

 

[Joseph Meehan]

Thanks. I don't know if you can explain this to me in words. I have
an invention table with a unique App number for each. There are six
inventors. I have an Inventor table. Of course, the inventors want
their names listed in order of importance, biggest guy first. So one
would be Inv1, next Inv2, etc. There are many inventions and many
inventors. How do you link them? Or query them?

First do any of them share an invention?

If not it is easy but you need to add that Inv1 Inv2 ... to a filed in
the invention table. After than you set up a relationship (one to many)
between the two tables.

Once that is done you can put both tables in a query and chose how you
want it sorted. It sounds like you will want to sort by inventor and then
maybe by anything you want in the invention table (like date registered or
name etc.) You don't need a second criteria if you don't need it.