Hi, I am a little new. I have used this forum since joining about one month ago, and have seen wonderful successes: because of the contributions of the other members. So thank you! I am able to do many advanced things in Excel, but am learning in Access.

My task is to build queries from existing tables that hold fields with data numbers (order volume counts) related to Dates (month/day/year). I could Sum these into spreadsheet tables in Excel, but I need to learn Access.
So I have many basic tables, that contain (columns of) volume numbers, representing orders (rows) by date (another column) per day, per months of Jan-Feb-Mar-Apr) for about 15 different products. These basic tables are specific per product, so Product A has orders in rows, with columns showing volume counts and monthly dates...however, the dates run from Jan to Apr.
How do I build and run a query to collect each month per product, and sum the order numbers by the month, for each product?

Thanks in advance.