-
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules