Append Query not bringing in all data

Hi!   I have (3) queries in my application that represent 2017, 2018, and 2019 sales by period/year.   I appended queries 2 and 3 to query 1 to get a holistic view of all the data.    When I vi...