Hi,
First let me say that I did not create this database but rather inherited from someone else.
I have two tables, "tblProductCurrent" & "tblProducts" which store information about our products and their policy numbers. Both tables have the same fields, "PolicyNum", "ProductName". "tblProductCurrent" contains the most accurate information as it is updated.
I am trying to compare the two tables to see if there is any difference in data. The "ProductName" is most likely the same for boh tables but the "PolicyNum" may be different. So, if the "PolicyNum" is different between the two tables, I would like the query to show it.
Hope that makes sense! Thanks!