[AccessD] Creating a Project Plan in Access 2002

Hi Barb:

It might be better, if you require an updatable form, that you take control
of the form contents by using an unbound form and manage the any data
changes or additions behind the 'scenes' with code.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Thursday, October 27, 2005 6:27 AM
To: Access List
Subject: [AccessD] Creating a Project Plan in Access 2002

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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com