Work Schedule database (coming from Excel)

I'm trying to convert an overgrown and overly complex Excel file to Access
but I'm stumped on the best way to set things up. I'm scheduling monthly
work hours for four positions on each of about 200 projects. I'll always be
looking at about 24 months at a time, beginning with the current month.

My excel file looks basically like this

Month1 Month2 Month3 . . .
Project1 Staff1 0 30 20
Staff2 50 50 50
Staff3 20 20 70
Staff4 10 10 0
Project2 Staff1 0 20 70
Staff2 0 10 0
Staff3 0 20 70
Staff4 0 50 50

The tangle is that I will have to export this back to a similar Excel format
quarterly to send it to management. The months must be listed horizontally
and the four staff positions must be on separate lines. I've tried four or
five different approaches for setting up my tables and reports, but I can't
figure out how to make the thing do what I need it to without getting so
complex that it locks up my computer when it tries to run the reports.

It seems like it should be so easy. Please help!

The tangle is that I will have to export this back to a similar Excel format
quarterly to send it to management. The months must be listed horizontally
and the four staff positions must be on separate lines.

A crosstab query will put months listed horizontally and the staff positions
on separate lines.
--
KARL DEWEY
Build a little - Test a little


"Dojie" wrote:

I'm trying to convert an overgrown and overly complex Excel file to Access
but I'm stumped on the best way to set things up. I'm scheduling monthly
work hours for four positions on each of about 200 projects. I'll always be
looking at about 24 months at a time, beginning with the current month.

My excel file looks basically like this

Month1 Month2 Month3 . . .
Project1 Staff1 0 30 20
Staff2 50 50 50
Staff3 20 20 70
Staff4 10 10 0
Project2 Staff1 0 20 70
Staff2 0 10 0
Staff3 0 20 70
Staff4 0 50 50

The tangle is that I will have to export this back to a similar Excel format
quarterly to send it to management. The months must be listed horizontally
and the four staff positions must be on separate lines. I've tried four or
five different approaches for setting up my tables and reports, but I can't
figure out how to make the thing do what I need it to without getting so
complex that it locks up my computer when it tries to run the reports.

It seems like it should be so easy. Please help!