I want to compare two or three tables and print that parts that are different. Is there a way to do this in access? I have been looking around and now my brain is starting to get fried.

The Find Unmatched Query Wizard can assist you in this. Click Queries in the list, then New on the short toolbar right above the database window. He is in that list. Just click and follow the steps.

I initially would have answered just as Frank did .. but then I started thinking ... which is not always good! ... That maybe you meant the structure of your tables and not the data the resides with in them .... Is that the case? ... If so, the unmatched query is not the "trick" you need.

Are the two/three tables having the same structure ... and do you want to detect whether there is for a "same id" a diffference on the field-values?

In that case the 'Find unmatched query wizard' can not help you ...

By using vba-code it is possible to create a list with the "differences" between the tables ..

More info is needed to better help you

Greetz from Belgium

Luc aka Kuifjexx

The structure is the same, I mean the data that resides in them. I am going to try what Frank said and I will update everyone if it does what I need it to do. Thanks

An 'Find unmatched query wizard' searches in the related table whether the record of the base table has not a related record ...based on matching field.

So it will not be the solution for your problem ...

Greetz from Belgium

Luc aka Kuifjexx

Yea, I just found that out. Here is what I have. I have two tables, with the same kind of data, addresses. One set was run through a certain program and the other set through a different program. What I need to do is compare the address in both tables and display the ones that are different, but I need to see both views.