Append unmatched query in Access

  • Hi Team,


    I am trying to append the unmatched query but getting the error message as "Duplicate Output Destination".


    What actually am trying is to identify the unmatched line.

    Eg: in table "A" i have 2 records and in table "B" 3 records

    and i want to append/insert unmatched query result in table "A".


    Should compare or match between "Field1" in both the tables.


    I request you to kindly advise on this.


    Note: I will provide the link in case of cross posting.


    Thank you.


    Regards,

    Rehaman.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!