I want to display differences in percentages by month or day

[hogtied]

Hello Members,

I have two tables,
1. Orders - include order information
2. Products - include product information.

Then I have 3 queries,
1. The total amount of orders.
2. The total amount of orders grouped by products
3. Combine 1 & 2 to return percentages.

What I would like is a query that tells me by month or day the changes in percentages. For instance

Jan2003 -- 100 orders -- 20% -- ProductA
Feb2003 -- 80 Orders -- 18% -- ProductA -- -2%

how can I have this down. Or is there even a way to do this?

Thanks,