Filter records by week and create new records

[jnb22019]

Update:



This is what I have:

Incumbent (table) - Agency, Name, rate, hours worked, total hours worked, week.
Week (Table) - Week (Key)
PO (Table) - Agency (Key), Purchase Order

PO (Form) - Shows all names, rates and total hours worked for each PO and Agency (names, rates and total hours been part of a subform)
Week (Form) - Shows all names, rates and hours worked by week. (names, rates and hours worked part of a subform)

To make this work I had to write records of weeks in the Week table (7/3/11 - 7/10/11, and so on) until the end of the year and in the subform paste all the records of names and rates, as hours are still blank, on each Week record.

What I want is an easier way of been able to filter records by week and be able to add the hours worked on each Name record per week and Sum all the hours at the end for the Total Hours of each Name record.

At the by doing this I now have 4000 records on my Incumbent table.

Please help.

[orange]

I suggest you use the Form wizard. Select the name of your table in the wizard's drop down, and let Access build the Form for you.

[jnb22019]

Solved my problem. Just had to reorganize my tables ans divide my data into more tables. Managed the relationships and for the form I created the main form with a subform and another subform to that.

[orange]

Glad you got it working.