Creating a report with variable of columns

[sggmm]

I am new to Access database and need to create a report like below:

03/06/2002 10/0602002 17/06/2002......
Project A
Manager
Alex 60% 80% 80%.....
Ben 60% 60% 100%.....

Staff
Cherry 40% 50% 0%.....
Dean 20% 30% 100%.....

Project B
and so on.......

User can select how many weeks he wants for his report and the report is only shown the number of weeks required.

Also, the data entry staff wants to keep the input table format as follow:

Client_ID Resource_ID 3Jun 10Jun 17Jun 24Jun.......
1 1 60 80 80.....
1 2 60 60 100.....
2 5 40 50 0.....
2 6 20 30 100.....
and so on

I know the database stucture is odd, but let assume I cannot change the format of the input table. I tried multiple-column report but got stuck at the end.

Can anyone help me out of this or suggest alternative method to create such a report? Thanks very much!

 

[Junior1544]

the first thing i would do is change the table structure... i know you said you can't because the users don't want it... but as the admin you need to look beond that... give them what is good for them even if they say they don't want it...

just make a form that looks the way they want, and have them use that...

now to table structure... you should be using multiple tables with a one to many relationship... (that's where i start to get fuzzy, i don't have much experience with relationships...)

but you will need a table that has the client id, and resource id...

then you will also need another table that has a forign key ... i would suggest the client id) and then a date and a number...

that way when time moves on you wont have to go in and change table structer to acomidate new dates, and it keeps a history... because you don't have to delete old data...

and as to the report you're looking at making... look into a cross tab report... i know very little about it, but look into help files on that...

--Junior JHauge@jmjpc.net
Life is change. To deny change is to deny life.