table design question

[mcgraw]

I have an Access 2007 DB we are using to both track issues, and do some project management on.

My boss wants to add a function to it where it will show how many days a project has been assigned to a specific location (these projects will get assigned to us for testing, then assigned to another group for validation, then to another group for acceptance, and can get bounced back and forth until completed)

So, two functions need to be accomplished:

1: How long has it been with a specific group
2: How many TOTAL days (with all the bouncing back and forth) has a group worked the project.

I'm not sure how to setup the table to get this started. I guess I would need a Assigned to Group, Start Date, End Date, ID and Master ID to link back to the main Issues table.

Just curious if anyone has something like this, and what the structure of the table is like.

Thanks!

 

[jdraw]

I have an Access 2007 DB we are using to both track issues, and do some project management on.

My boss wants to add a function to it where it will show how many days a project has been assigned to a specific location (these projects will get assigned to us for testing, then assigned to another group for validation, then to another group for acceptance, and can get bounced back and forth until completed)

So, two functions need to be accomplished:

1: How long has it been with a specific group
2: How many TOTAL days (with all the bouncing back and forth) has a group worked the project.

I'm not sure how to setup the table to get this started. I guess I would need a Assigned to Group, Start Date, End Date, ID and Master ID to link back to the main Issues table.

Just curious if anyone has something like this, and what the structure of the table is like.

Thanks!

This might be helpful.

http://www.allenbrowne.com/casu-22.html

Use a naming convention;
plan your database,
make a model,
test the model with questions you need answers to

 

[mcgraw]

Thanks, I'll take a look. I have a LOT to learn about how DBs work, and stuggle with the normalization and not repeating data!

Thanks for the link!