Building multiple tables from 1 Query

[canefan17]

I have a folder I’m importing monthly files from. I will have the main table be my “2019 Total Sales Data” table.

However, I’m wanting to break that same data out by month (Jan, Feb, Mar.... tabs at the bottom).

I know that I could just duplicate the main query 12 times (giving me 13 total queries, all pulling in the same data, but then filtered by month).

I just want 1 Query to do all of this though. Possible?

 

[Misca]

I don't think it's possible to load a single query to several tables. The closest thing to that would be if you created a pivot table from your data / query and used the "Show Report Filter Pages" feature found from the Options-menu on the Analyze-tab.