G
Guest
I'm not sure why I'm having difficulty with this and I'm sure I'm missing
something simple. We gather statistics from different locations using a
paper form and at the end of the day or the next we take all of the forms and
tally them together. For awhile this was done in excel. I converted it to a
database to improve functionality and report gathering. What I'd like to do
and have partially done, is create a form that looks similar to the paper one
and then just throw the numbers into the database from the paper form.
I've got it set up so that all of the tables are linked appropriately
through queries and relationships and can update the various records from one
form. The trouble is that I have to do the addition prior to inputting.
Because the paper forms come in at different times, and sometimes they only
arrive after a week, I have to take the numbers already in the database and
add them to the numbers already in the table then input the number (replacing
the old) into the form. It seems like I should be able to add a function
somewhere to the field property in the form to do this calculation for me.
I'd like to avoid making a query where it asks me for every number one at a
time which has been the solution I've thought of... it's probably faster for
me to do the calculations by hand.
Any ideas? I'm thinking along the lines of an update query where it
asks you for input, but I'd like one form that displays all input boxes at
once and I can rapidly put the numbers into the fields and it takes those
numbers and adds them to numbers already in the table.
something simple. We gather statistics from different locations using a
paper form and at the end of the day or the next we take all of the forms and
tally them together. For awhile this was done in excel. I converted it to a
database to improve functionality and report gathering. What I'd like to do
and have partially done, is create a form that looks similar to the paper one
and then just throw the numbers into the database from the paper form.
I've got it set up so that all of the tables are linked appropriately
through queries and relationships and can update the various records from one
form. The trouble is that I have to do the addition prior to inputting.
Because the paper forms come in at different times, and sometimes they only
arrive after a week, I have to take the numbers already in the database and
add them to the numbers already in the table then input the number (replacing
the old) into the form. It seems like I should be able to add a function
somewhere to the field property in the form to do this calculation for me.
I'd like to avoid making a query where it asks me for every number one at a
time which has been the solution I've thought of... it's probably faster for
me to do the calculations by hand.
Any ideas? I'm thinking along the lines of an update query where it
asks you for input, but I'd like one form that displays all input boxes at
once and I can rapidly put the numbers into the fields and it takes those
numbers and adds them to numbers already in the table.