Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Error on Query Values

    Code:
        s = "INSERT INTO tblAnswers ( QuestionID, Seq_Number, EmployeeID  )" _
          & " SELECT QuestionID, " & Me.Seq_Number & Me.EmployeeID _
          & " FROM tblQuestions " _
          & " WHERE tblQuestions.IsActive=True;"
    I am getting a run-time error 3346. Number of query values and destination fields are not the same.

    When I take out either the EmployeeID or Seq_Number it works.

    Any ideas?

    Thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    & " SELECT QuestionID, " & Me.Seq_Number & ", " & Me.EmployeeID _
    Paul

  3. #3
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113
    Much Thanks Paul!!!
    ======================
    Levent
    Access 3

Posting Permissions

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