Home

Products
>SQL Wizard | Access Add-in
>Data Change Analyzer| Access
Add-in

>Consolidate & Update Wizard | Access Add-in
>Median Finder | Access Add-in
>111+ Power Access Queries/SQLs
>Duplicates Finder | Access Add-in
>Duplicates Filter | Excel Add-in
>Excel Tips & Tricks

>Macros Finder | Excel Add-in

 

Consolidate & Update Wizard | Access Add-in


You select your base table to be updated.

_______________

You select your table with which to update your base table.

_______________

You select the type of operation for your update: You can either add your monthly data to the base table or substract it from the table.

You can also append those unmatched records, if any, to the base table. If you don't want to append them, you still can see what they are in a table.

_______________

These are the two tables you selected. Notice that both tables contain duplicate customer names.

_______________




These are what you get after the wizard processed your requests. Notice how the wizard consolidated the two tables and updated the base table. Since you chose the subtraction option, the monthly data was subtracted from the base table data.
The wizard also appended those unmatched records to the base table, showing you what they are in a table.

 




We offer an unconditional 30-day Money Back Gurantee and free e-mail support! Your order is secured via RegNow SSL Secure Server (see RegNow Security/Privacy statement). You will be able to download the product immediately after ordering!

Copyright © 2010 MrSpreadsheet, LLC. All rights reserved.
Excel, Access are registered trademarks of the Microsoft Corporation.