I've lost some data, but thankfully were dilligent about creating backups.

Now I just need to know how to replace what we've lost.

I have two tables / Table1 and a backed up copy of Table1 I will call Table2 for the sake of clarity.

I have 4 fields that i need to take from Table2 and place those values in Table1. The [Account Name] Field is my constant, here's the curveball, I only need to update records that were touched prior to a date which we record in a field called [Today's Date].

Any help is always appreciated.