Re: data entry through the form
What mike60smart was trying to tell you is this: Once you have data stored in a table, you do not need it in another table. You can use a query that would manipulate and filter and reformat and compute as needed. Storing the same data in two tables is not only wasteful of space but runs a SERIOUS risk of data between the two tables getting out of alignment or desynchronized.
You want this in another table for reports - but Access reports work PERFECTLY well using queries as their basis.
What you SEEM to be asking is that you want to use Access like a spreadsheet. Which it is not. Copying from table a to table b and using letters as field names makes me believe you are trying to adapt a spreadsheet that has become too difficult to manage. But there is more to Access conversions than just moving data to another table. This might not be the answer you wanted to hear but it IS the truth.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.