Results 1 to 2 of 2
  1. #1
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34

    Append query not working

    Hi guys,



    Can anyone help me write my append query, here is the SQL:

    INSERT INTO [In Progress - Responding tbl] ( [In Progress - Responding tbl] )
    SELECT [In Progress-Responding].Received
    FROM [In Progress-Responding];


    I get an error message say the insert into field name is not valid? but the table exists!

    Thank you!

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    So you have a field in a table with exactly the same name (In Progress - Responding tbl)
    You want to append data from a field called Received in another almost identically named table In Progress-Responding

    If that's what you have /want, you really need to do something about your naming convention.

    EDIT: Full answer now given in separate post https://www.accessforums.net/showthr...868#post389868
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Append Query not Working for Specific User
    By heather in forum Access
    Replies: 8
    Last Post: 01-09-2017, 03:15 PM
  2. Append Query Stops Working in RunSQL Command Question
    By McArthurGDM in forum Programming
    Replies: 6
    Last Post: 06-11-2015, 11:17 AM
  3. Replies: 1
    Last Post: 01-16-2013, 10:58 AM
  4. Append query not working
    By seth.murphine in forum Queries
    Replies: 5
    Last Post: 04-20-2012, 06:41 PM
  5. Paste Append not working
    By martinshort in forum Access
    Replies: 3
    Last Post: 01-20-2012, 07:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums