I WANT duplicates

[Guest]

Fields in the table are
Last_Name,First_Name,Emp_ID,Hours_Day,Days_Week,Week_Number,Project,Cost_Typ

All fields come from a form. On the form is a Start_Week and Duration combos
I can create a table with the fields listed above with a start week (number). Then add a record with the same information changing the start_week number by adding the duration to it. The problem arises when I need to fill in the records in between. I tried to pass off the above table with just the addition of a Duration field in it, but the boss said I needed to populate the table with individual records that increment the week_number field
Any help would be greatly appreciated!

 

[Joseph Meehan]

Fields in the table are:
Last_Name,First_Name,Emp_ID,Hours_Day,Days_Week,Week_Number,Project,Cost_Typ
e

All fields come from a form. On the form is a Start_Week and Duration
combos.
I can create a table with the fields listed above with a start week
(number). Then add a record with the same information changing the
start_week number by adding the duration to it. The problem arises
when I need to fill in the records in between. I tried to pass off
the above table with just the addition of a Duration field in it, but
the boss said I needed to populate the table with individual records
that increment the week_number field. Any help would be greatly
appreciated!

Normalization. You can look it up in the help file.


It sounds like you need to split the table. The things like name that
stay the same in one table linked to a second table with the weekly changes.
Then you use a query to put the data back together so it appears to be one.

That way you don't need to keep repeating the data every time you add
additional data.

Trust me on this. It will take a little time to get the concept, but it
will be worth it.

 

[Joseph Meehan]

Sooo I normalized the table. I removed the duplicate information. I
still have one problem.
I enter in a start week, duration in the new (no duplicate) table.
Say the hours are 4 per day, the days per week are 5, (this gives you
20 hours per week). The start week is the 15th week, and the
duration is 4 weeks. When I need to display a chart
with 20 weeks in a row starting with the 15th week,
I can't get the chart to display the additions (reoccurence) of hours
per week
for the duration. This is why I wanted to duplicate the fields
(except for the week number) and have the form create the (in the
example above) 4 records.
Any help would be great!
Thanks in advance!
Steve

That sounds like you now need to make a query to put it all back
together again. Then use the query as you would have used a table. The
query should show all the information that would have been duplicated from
the table containing it and the detail information from another table. The
tables need to be joined (you can do this in the query) so that each
record of the detail is shown.

Hope that makes sense and I hope I understand what you are wanting to do
and what you have correctly.

You should see an example of this in the sample database (Northwind)
included with Access