Solved

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

Posted on 2013-01-23
1
148 Views
Last Modified: 2013-11-04
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?
Quarterly-Rate-Updates.pdf
0
Comment
Question by:rgerl01
1 Comment
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 38810890
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
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now