R
RA
I collect reports weekly from an automated system. I save the reports as
individual tables in Access. All of the fields are identically names. I
need a query that will look through the newest table and comparer it to the
prior table (I know that part may be manual) and show only the items that
changed, old value and new value (and the additions or deletions in a single
query would be nice)
individual tables in Access. All of the fields are identically names. I
need a query that will look through the newest table and comparer it to the
prior table (I know that part may be manual) and show only the items that
changed, old value and new value (and the additions or deletions in a single
query would be nice)