Displaying findings across multiple tables in one layout
I have been tasked with constructing a database for my company that will allow me to import a csv file to keep track of billing per minute.
Each affiliate has it's own table to keep track of it's billing minutes each month. The month field is automatically populated when new records are imported.
I've set up a layout that will show a snapshot of each affiliates total billing minutes for the month and the name of the affiliate. The issue that I'm having is filtering the results for the month.
How do I make it so the snapshot layout only shows the current months billing for all of the affiliates on different tables?
Any help will be greatly appreciated.