Blitskrieg
04-13-2011, 01:58 PM
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.
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.