I
IrishRed
Hello,
I am working on a project to take two unlike tables and make them as like as
possible so that I can compare them and report any discrepancies.
I have made them as 'like' as I can so that I can do the compare. When it
comes to discrepancies I am struggling a little bit. I am able to do one
compare where I do a join on two fields and tell access to show me all from
query one and only those from query2 where the joined fields are equal. I
think that I would need to do more but I am just not sure what approach to
take to get any other discrepancies.
Just looking for some suggestions on the right direction to take this.
Thank you very much for your time.
I am working on a project to take two unlike tables and make them as like as
possible so that I can compare them and report any discrepancies.
I have made them as 'like' as I can so that I can do the compare. When it
comes to discrepancies I am struggling a little bit. I am able to do one
compare where I do a join on two fields and tell access to show me all from
query one and only those from query2 where the joined fields are equal. I
think that I would need to do more but I am just not sure what approach to
take to get any other discrepancies.
Just looking for some suggestions on the right direction to take this.
Thank you very much for your time.