I have a garden center where we create custom hanging baskets for our clients.  I have created the product, customer and order tables, forms etc. and now I am wanting to track the number of plants that are going into the baskets.  There are several mixes, and several different plants going into each mix.  I have an orderQ that lists the mixes and their plants (by ID Number, related to the PlantListT).  What I need to do is multiply each plant by the quantity ordered, and then add up all that for the rest of the orders.  For instance, I might have pink petunia in several orders, and several in each order.  It gets a bit more complicated as with one size basket, the quantity needs to double. I will try to clarify this in the photos. I want to get a total of each plant for the entire table but i am not sure how to go about this.  Any help will be much appreciated.  Photos following...