how do I create a report or query that displays only the diff.

C

Cornel

How do I create a query that only display the difference between two databases?

Database1 Database2
11 11
12

In this example, the query should display 12 (the difference between the 2
databases)
 
D

Duane Hookom

Do you really mean "tables" rather than "databases"? There is a query wizard
that can find unmatched records from two tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Select From External Access Database with path entered as Input parameter in query 0
independent path queries?? 5
Using LINQ to SQL with multiple databases 1
Help? Creating 'virtual table' to lay multiply data presentation 2
Inner Join Query on 2 linked tables 3
Database that is independent of path 5
How to choose only the first record from a query 4
Access Report 4

Top