Creating Phone Directory

[Guest]

I'm working on a emergency contact list that will be divided into departments
and I'm wondering the best way to tackle it. I used Lotus Approach years ago
when I was in the Marines, but of course Access is a little different and I'm
rusty as it is. I'm going to want to divide reports into pages for
departments and then sub-divide by foremen, sub-foremen, etc Will this work
in Access or should I be trying something else? How can I sort by
departments without necessarily publishing the department titles along with
every entry? Any other suggestions are welcome.

 

[Rick B]

The report wizard will help you sort and group.

In short, you will sort and group by department. You will have a group
header that includes the department (to print only once). Your group footer
would include a page break. Your secondary sort would be foreman, then
sub-foreman, etc. See if the wizard will get you through it. If not, get
started and then post back with some specific questions and we can help you
out.

You should be able to do exactly what you are asking for in Access.

 

[Guest]

Set your table up so it has fields for Department and Title included in the
record. I would suggest rather than the actual department and title names,
you use codes so they will sort in the order you want them. Then create a
child table for each that has the Title Description and Title code in each so
they can be displayed.

To set up a report, use the Sorting and Grouping option to arrange the
entries by department and title. You can set up a group for each level of
title. If you put the department title in the group header, you will see it
only once per department. Same with the titles. So what you would see would
be something like:

Department Title
Forman
Freddy Freeloader 555-213-3131
Sub Forman
Lotza Luck 555-213-4231
Benny Jet 555-213-8867
Field Tech
Larry Lugwrench 555-213-9093
Jack Hammer 555-213 6395

 

[Guest]

Thanks for the tips, very helpful... Okay I've got the groups set up but I
want to create a page break between the groups. I put the groups together
using Sorting and Grouping, but if the groups go over one page, another group
will lump in on the last page of the group.

 

[Mikal via AccessMonster.com]

Thanks for the tips, very helpful... Okay I've got the groups set up but I
want to create a page break between the groups. I put the groups together
using Sorting and Grouping, but if the groups go over one page, another group
will lump in on the last page of the group.

I'm working on a emergency contact list that will be divided into departments
and I'm wondering the best way to tackle it. I used Lotus Approach years ago

[quoted text clipped - 4 lines]

departments without necessarily publishing the department titles along with
every entry? Any other suggestions are welcome.

In the sorting and grouping dialog box, select "Whole Group" in the Keep
together box. That ought to do it.
Mike

 

[Guest]

Actually we are using codes for the departments, but how do you create a
"child table"?

 

[Mikal via AccessMonster.com]

Thanks for the tips, very helpful... Okay I've got the groups set up but I
want to create a page break between the groups. I put the groups together
using Sorting and Grouping, but if the groups go over one page, another group
will lump in on the last page of the group.

I'm working on a emergency contact list that will be divided into departments
and I'm wondering the best way to tackle it. I used Lotus Approach years ago

[quoted text clipped - 4 lines]

departments without necessarily publishing the department titles along with
every entry? Any other suggestions are welcome.

Sorry, I mis-read your post. To force a new page after each group, create a
group footer and under the format tab of the properties list change the
ForceNewPage property to "after section".

Mike