Database Design - Monthly Forecasts

[dvlander]

Suppose I have a table of project assignments. Each of these assignments
will have selected data for the future X number of months such as forecast,
projected utilization, actual utilization. Is it poor design technique to
have separate fields within the project assignment table such as
Jul09Forecast, Jul09ProjUtilization, Aug09Forecast...?

Does it make more sense to create a separate table with monthly fields
(Month, Forecast, ProjUtilization, ActualUtilization) and then link it to the
assignments table?

Thanks, Dale

 

[Jeff Boyce]

Yes.

Yes.


Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Yes.

Yes.


Regards

Jeff Boyce
Microsoft Office/Access MVP

Accuracy and economy of phrasing... good 'un, Jeff! <g>

 

[Jeff Boyce]

John

My wife regularly reminds me that I have fewer words to use each day than
she does...<g>

Jeff B.