Time series data columns

[averhegn]

I would like to develop a form showing rows for tasks and columns for dates.

I have a table of tasks and a table of hoursWorked, one record for each date
/ task.

Any thoughts on the best way of accomplishiing this?

 

[Piet Linden]

I would like to develop a form showing rows for tasks and columns for dates.  

I have a table of tasks and a table of hoursWorked, one record for each date
/ task.

Any thoughts on the best way of accomplishiing this?

use a crosstab query.

 

[averhegn]

I forgot to say that the time series data needs to be updateable.