Open menu KS DB Merge Tools logo AccdbMerge logo

Compare Query Results

In this use case, we compare the result sets of a query between two MS Access databases. You’ll see new and changed rows, identify differences by key columns, and review field-level changes. This feature is available only in the Standard version.

  1. Open databases (see the Project Changes Summary use case) and A click Queries.

    for MS Access, Home tab click queries
  2. In the opened Object list, click B Compare data for the required query. Then C specify the key columns combination and D click OK

    for MS Access, Object list tab click Compare data
  3. The Data diff tab opens with query comparison results. A row present in both databases with different values is counted as changed (highlighted in red). A row missing in the target is counted as new (green). Use filter E to show only new or only changed rows. The header shows F total counts, and the footer shows G column-level differences for the selected row. For large text values, click the column name in the footer H to open a separate Text diff tab with the value comparison.

    for MS Access, Data diff for queries