DB Design Question

[Guest]

Hello everyone,
I am trying to create somewhat of a MSProject Database.
User will enter employee's name, job (JOBID), Start Date, End Date. The
twist is each JOBID has hrs per day associated to it. So one employee could
have multiple jobs scheduled for the same day.
The end result will be a big ole chart/spreadsheet that lists (by employee
and overall) each week of the year and the total hrs for that week.

Is the best approach to create temp tables at query runtime to generate an
excel spreadsheet to export?
Or should I throw all of this in a table, generating an entry for each
project for each week between Start and End dates?

Or any sample databases out there they may have similar functions?

Thank you for your assistance.

 

[Duane Hookom]

How does this question differ from your question yesterday with a subject of
"Which Approach?"?

 

[PC Datasheet]

Contact me at my email address below. I can help you.

 

[Guest]

Duane,
Same question, sorry for the double posting. I received error message
yesterday when it posted, so I did not think it posted.