How do I calculate monthly sales in access?

See more:

MS-Access

calculator

reporting

Hi, I'm making a database in access for a small business that sells curtains, blinds, cushions and various other products. I need to make monthly reports for each product, however i'm not sure how I would go about doing this. So far I have made a query for calculating the total price of an order by mutltiplying the quantity by the unit price.

The tables and queries I have so far are:

Customer table:

Customer ID (PK)
First Name
Last Name 
Age
etc

Product Table:

Product ID (PK)
Name
Type
Size 
Unit Price

Order Table:

Order ID (PK)
Order Date
Customer ID (FK)

Order Details Table:

Order Details ID (PK)
Order ID (FK)
Product ID (FK)
Quantity

Order Prices Query:

Quantity
Name 
Unit Price
"Total Price"
Product ID
Order ID