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.



Participate now!

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