Report problem

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

Good afternoon all!

I work with employee benefits (Life, Health, Dental etc.)
I have several tables in a database including:

- benefit types (Life, health etc)
- Employee groups (Vancouver Salaried, Vancouver Hourly,
Victoria salaried, Toronto Salaried etc...)
- Insurance Companies
- Insurer policy numbers

I want to have a table that lists the employee groups down
the left side, and the benefits across the top. Then, the
data for the table will be both the insurance company, and
policy number. Basically, an at-a-glance sheet.

I have been able to create a pivot table formatted the way
I want, but since there are 40 employee groups, I can't
format it to be a practical document. My questions are:

1) Is it possible to create another Access object that is
more user friendly with the same info?
2) Can I export a pivot table into word somehow so I can
re-format it?

HELP!!!
..
 
I love these newsgroups! Thank you Duane! When I am really
smart I will try to give back like you MVP's do!
 
Back
Top