I have Table1 and Table2 with a common field named "Prefix"
Is there as Access method to see if they're identical; or use Recordsets and compare each field individually?
I have Table1 and Table2 with a common field named "Prefix"
Is there as Access method to see if they're identical; or use Recordsets and compare each field individually?
Explore the Find Unmatched query wizard.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.