Forum Discussion
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...
Brysonds ,
Have you checked to make sure all columns have the same data types and names for all the queries?
Hi Nick,
Yes, I have checked that. In fact Query 2 and 3 are a copy of Query 1. The only difference is the parameter value for the data source for the date range of data. Other than that, they are identical in every way.
If I view the data of any single query using that query source, then everything is exactly right. It's only when bringing all 3 together that I see the issue.
I checked the table view row values for each query, and see that hundreds of thousands of records are missing.