Which Approach?

24 Feb 2005 11:39 PM

David

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.

--
David

25 Feb 2005 12:55 AM

Duane Hookom

I would do it all in Access. You might want to create a table of every work
day. You can then create queries that add the hours per day for each
employee for each JOBID.

Not sure what you big ole chart would look like but I would probably do this
in Access also.

--
Duane Hookom
MS Access MVP

Show quote

"David" <Da***@discussions.microsoft.com> wrote in message
news:17558FFA-C076-496A-9CEE-2AA61350D328@microsoft.com...
> 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.
>
> --
> David