Consulting

Results 1 to 2 of 2

Thread: Access - SQL Query to repair table.

  1. #1

    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.

  2. #2
    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
  •