I have a very simple table and would like to have a form that will fill in 35 records at a time. The table consists of the follow fields
Date, Facility, Part Type, Quantity
There are 5 facilities to choose from and each is capable of making the same 7 types of parts. Each day I want to capture the number of each part type produced by each facility. Some of the values for the quantity will be zero if a particular part was not produced at a facility for that day. I want to capture the zero data as well since it will play a role in calculating the average over a range of dates.
Currently, this data is captured on a paper form (a new paper form is used each day to capture all 35 data points) Is it possible to design an Access form that would show the 35 records and allow the user to update the non-zero records for the day ? Essentially duplicating the paper form ?
I know how to set up a continuous form that would let me add one record at a time, but can I set up a form that will show all 35 records for the day on the screen so all the user has to do is enter the quantities for each part type?
Thanks in advance for your help.
Date, Facility, Part Type, Quantity
There are 5 facilities to choose from and each is capable of making the same 7 types of parts. Each day I want to capture the number of each part type produced by each facility. Some of the values for the quantity will be zero if a particular part was not produced at a facility for that day. I want to capture the zero data as well since it will play a role in calculating the average over a range of dates.
Currently, this data is captured on a paper form (a new paper form is used each day to capture all 35 data points) Is it possible to design an Access form that would show the 35 records and allow the user to update the non-zero records for the day ? Essentially duplicating the paper form ?
I know how to set up a continuous form that would let me add one record at a time, but can I set up a form that will show all 35 records for the day on the screen so all the user has to do is enter the quantities for each part type?
Thanks in advance for your help.
