Data Change Analyzer | Access Add-in
1) Examples - Type A
You select the first of your two tables.
This wizard does not list any invalid tables/queries, i.e., any empty
tables/queries or queries whose base tables were renamed or deleted.
_______________
This is your base table.
_______________
You select the second of your two tables. The name of the base table does not
show up on this list so that you can avoid selecting the same table twice.
_______________
This is your current table.
_______________
You choose to run a query.
You can change the default query name.
_______________
This is what you get after pressing the Finish button
This query captures the changes from the Base table to the Current table
into the three categories:
1. Existing (Values exist in both tables)
2. New (Values exist in the Current table only.)
3. Lost (Values exists in the Base table.)
_______________
[click on image to enlarge]
This is a side-by-side example of two input tables and an analysis output.
_______________
You can choose this option if you want a table as your report.
_______________
This is what you get after pressing the Finish button.
This table is identical to the above query outcome.
_______________
2) Examples - Type B
This example is identical to the Example Type A except that your tables don't contain a numerical column.
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!
|
