Results 1 to 3 of 3
  1. #1
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108

    Access can't append all the records in the append query

    Can anyone help me with this pop up error
    Click image for larger version. 

Name:	Capture.JPG 
Views:	13 
Size:	50.0 KB 
ID:	21829



    Please. Thanks in advance


    This code was highlited in yellow when I press "No"
    Code:
    DoCmd.RunSQL LoadSummaryHighSQL
    Here is the code that i'm trying to run
    Code:
    'To re-capture the summary of the latest load data
            DelSummaryHighSQL = "DELETE SummaryHigh.*, SummaryHigh.Record_Period FROM SummaryHigh " & _
                            "WHERE SummaryHigh.Record_Period In " & _
                            "(Select Load_Period From [Setting] Where [Setting].[Type] = 'LOAD_DATE')"
            DoCmd.RunSQL DelSummaryHighSQL
            
            
            LoadSummaryHighSQL = "INSERT INTO SummaryHigh ( Record_YYYY, Record_MM, Record_Period, CATEGORY, " & _
                             "INSTITUTION, No_of_Recordset, LOAD_DATE, FIELDMATCHED ) " & _
                             "SELECT Year(DateAdd('m',-1,[Load_Date])) AS RECORD_YYYY, " & _
                             "Month(DateAdd('m',-1,[Load_Date])) AS RECORD_MM, Setting.Load_Period, " & _
                             "CategoryInsCount2.CATEGORY, CategoryInsCount2.INSTITUTION, CategoryInsCount2.FIELDMATCHED, CategoryInsCount2.NO_OF_GROUP, " & _
                             "CategoryInsCount2.LOAD_DATE FROM CategoryInsCount2, Setting Where [Setting].[Type] = 'LOAD_DATE'"
            DoCmd.RunSQL LoadSummaryHighSQL
    Here is the SQL query for CategoryInsCount2
    Code:
    SELECT GROUPING.CATEGORY, GROUPING.INSTITUTION, GROUPING.FIELDMATCHED, Count(GROUPING.GROUP_NO) AS NO_OF_GROUP, Max(GROUPING.LOADED_DATE) AS LOAD_DATE
    FROM (SELECT CATEGORY, GROUP_NO, INSTITUTION, FIELDMATCHED, LOADED_DATE FROM CrossSystemData WHERE INSTITUTION NOT LIKE "*UNKNOWN*" AND FIELDMATCHED="HIGH")  AS GROUPING
    GROUP BY GROUPING.CATEGORY, GROUPING.INSTITUTION, GROUPING.FIELDMATCHED;

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    1 of your fields is rejecting the data, due to
    wrong data type
    or
    validation rule
    or
    conversion failure.

    Check all table field settings to see which is rejecting data.

  3. #3
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108
    Quote Originally Posted by ranman256 View Post
    1 of your fields is rejecting the data, due to
    wrong data type
    or
    validation rule
    or
    conversion failure.

    Check all table field settings to see which is rejecting data.

    Thanks ! Its working . Appreciated your help!

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

Similar Threads

  1. Replies: 4
    Last Post: 02-25-2015, 06:32 AM
  2. Append Query Saving Multiple Records
    By jewll in forum Queries
    Replies: 5
    Last Post: 12-13-2014, 03:54 AM
  3. Replies: 1
    Last Post: 10-06-2011, 08:37 AM
  4. Replies: 7
    Last Post: 07-21-2011, 01:01 PM
  5. Append query won't append
    By yelkenli in forum Queries
    Replies: 5
    Last Post: 02-12-2010, 11:19 AM

Tags for this Thread

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