I have 2 queries. Basically combining 2 Company divisions. Query A and Query B. Both of these files are sourced from excel files. I have APPENDED Query B to Query A in the query editor. All the data from my original APPEND is in place as expected
I have now added new data for the next month to Query B however the refresh does append the new data from Query B and add to Query A I can see the new data is leaded into B query in the query editor and the desktop The APPEND is performing as if it is a one and done action.