Is there a macro to copy data from one field to another. Remove duplicate entry.

I have a form that requires the entry of contrilbution rates (i. e. 10%) for each month.  However each quarter is treated individually.  I would like to be able to copy the monthly contribution rates for one quarter to the next quarter.  This would reduce duplication of entry by at least 90%.

If there is a macro that I can use to do this, I'd like to know.  Unfortunately I am not capable in VB so that is not an alternative for me.

I've attached a PDF graphic to help you understand my need.

Any suggestions?
Who is Participating?
als315Connect With a Mentor Commented:
You can createappend query and run it when you need. May be you can upload sample DB with this table? Exact query could be made if we will know table structure
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.