I'm reviewing an access file that my company had already existing and trying to figure out what all the queries inside it do. While I am good at excel, I'm still very new to access, and don't really understand how to design an append query.
From the design view here is what I see:
In the top panel I have one box, Table2.
Then below i have
Field: Loc_A
Table: Table 2
Sort:
Append to: LOC_A
Criteria:
Or:
Is this append query appending the table2 to itself or is there a possible chance it is appending it somewhere else?
From the design view here is what I see:
In the top panel I have one box, Table2.
Then below i have
Field: Loc_A
Table: Table 2
Sort:
Append to: LOC_A
Criteria:
Or:
Is this append query appending the table2 to itself or is there a possible chance it is appending it somewhere else?
Last edited: