Comparing two reports to determine: Changed, Added, and Deleted

[brentfol]

Hello,

I need to develop 3 queries to compare two reports (last month vs. current month) to determine what has been changed, added, and deleted from the old report to the new.

I do not know how to write the query and/or relationship to compare the two related tables of data.

If you need more information, please le me know. Thanks in advance!

[orange]

If you are serious, then think about what you are asking and what info you have provided.

If you need more info

No one here is a mind reader.
So could you tell us about the application. Describe your situation in plain english as if you were give 2 minutes to tell us what your problem is? Why it's important?


What kind of data is stored?
What are the tables involved?
Show us the tables and relationship diagram.

How did you resolve your issues last month?

Why are the 3 queries needed now? You have reports, don't they do what you need?

These are just some of the questions people will need answers to in order to give you any assistance.