"David" <Da***@discussions.microsoft.com> wrote in message
news:415133A7-2E65-450F-ACDB-EBE79A0BBA27@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.
>

"Duane Hookom" wrote:

> How does this question differ from your question yesterday with a subject of
> "Which Approach?"?
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "David" <Da***@discussions.microsoft.com> wrote in message
> news:415133A7-2E65-450F-ACDB-EBE79A0BBA27@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" <Da***@discussions.microsoft.com> wrote in message
news:415133A7-2E65-450F-ACDB-EBE79A0BBA27@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.
>