Access - SQL Query to repair table.

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.

Here is what I've tried so far.

[VBA]
UPDATE [North Florida] SET [North Florida].[Notes / Comments 1] =
[North Florida1].[Notes / Comments 1] WHERE
[North Florida].[Today's Date] < '4/12/2011';
[/VBA]

It's the long way to code it but it's not working anyways so..