Barbara Ryan
BarbaraRyan at cox.net
Thu Oct 27 08:27:27 CDT 2005
I need to create a form (ACC 2002) that will populate a "project plan" table, defined (very basically) as follows: tblProjectPlan PlanDate (e.g., 03/01/05) WorkerType (e.g., "Plumber", "Carpenter", etc) Quantity (e.g., 10) There will be an entry in tblProjectPlan for each PlanDate/WorkerType (Primary Key) The form should be structured so each date in the project (e.g. 03/01/05 - 03/05/05) is a column and each WorkerType is a row. 03/01/05 03/02/05 03/03/05 03/04/05 03/05/05 Plumbers 8 7 6 6 0 Carpenters 3 3 3 3 3 Millwrights 0 0 1 1 0 I was going to use a crosstab query, but realized that it wouldn't be updatable. I was also thinking about creating a table with one record for each date --- the form could show the dates as columns. The WorkerType would be a dropdown box. Once the WorkerType was selected, quantities would be entered for each date. Would this work? Any ideas on creating a project plan in Access 2002? It doesn't have to look exactly like this. Thanks, Barb Ryan