Results 1 to 2 of 2

Thread: Update query

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Update query

    For i = 1 To 10
    If (Not (IsNull(["Invoice #" & i]))) Then
    sql = "Update [Input] SET [Date of Check] = #" & [Check Date] & "# where [Vendor Code] = '" & [Vendor Code] & "' and [Invoice Number] = '" & ["Invoice #" & i] & "'"
    End If
    Next i


    When I run it, there is problem for the [Invoice #1], [Invoice #2],....etc.

    Because I used ["Invoice #" & i]

    How can I edit it?
    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ah yes, I see your problem... You can edit it by fixing your table design. Check out that other post where we all told you to fix your table design for a few pointers on how to do that.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •