directory phone book

[Guest]

I am new user working Access 2003. I am trying to create a directory of
public libraries and their branches. I need to be able to sort the tables in
different ways and then print them out to create a directory. I have two
tables created each with a unique field names except for the 'library name'
for the main library. I made a relationship between the two tables wanting to
list all of the branch libraries under the name of the main library
information. Then I want to be able to print it out in a two column format
like a phone book.
Some of the other sorts are for all the libraries in one county or city, or
all of the libraries whose names do not match the city or county that they
live in.

 

[John W. Vinson]

I am new user working Access 2003. I am trying to create a directory of
public libraries and their branches. I need to be able to sort the tables in
different ways and then print them out to create a directory. I have two
tables created each with a unique field names except for the 'library name'
for the main library. I made a relationship between the two tables wanting to
list all of the branch libraries under the name of the main library
information. Then I want to be able to print it out in a two column format
like a phone book.
Some of the other sorts are for all the libraries in one county or city, or
all of the libraries whose names do not match the city or county that they
live in.

What is your question?

You cannot sort data in a Table - a table is an unordered bucket of data.

You can use a Report's Sorting and Grouping dialog to specify the sort order
of the records on the report. If you base the report on a Query joining the
main libraries to the branches, you can use the Group Header of the main
library field to display the library name, and control the sorting of the
branches.

You can use the Page Setup of the report to control the number of columns.

John W. Vinson [MVP]