estevan.sanchez
Thread Starter
- Joined
- Oct 2, 2008
- Messages
- 14
Semi beginner in Access 2003. My problem is I think a little complicated so here goes. On a specific week, our department will get a list mail renewal packets with 5 different expiration months. So I have to find a way to create a form (which I have done) with a week ending date that will allow the user to enter multiple expiration month dates. I figured how to do one at a time and get the form to update but can't figure out how to update all of them at the same time. The problem I think has to do with the control source but not sure. so here's a sample of the info:
For week ending 9/20/2008,
August September October November December
Opening Balance 1000 1200 1300 1500 1600
Received in Unit 200 100 50
Deferred
Deferred Closed
Deferred Pilot
Deferrals Return
Processed
Closing Balance
Mail Room Count
So I set up a form similar to the look above but can't figure out how to update it to a single table that has all the left handed information on it. Please help!!!!!
Thanks a million... You know bosses they want it particular way.
For week ending 9/20/2008,
August September October November December
Opening Balance 1000 1200 1300 1500 1600
Received in Unit 200 100 50
Deferred
Deferred Closed
Deferred Pilot
Deferrals Return
Processed
Closing Balance
Mail Room Count
So I set up a form similar to the look above but can't figure out how to update it to a single table that has all the left handed information on it. Please help!!!!!
Thanks a million... You know bosses they want it particular way.