Search results

I am attaching a copy of my database (with reports deleted due to size) that will show my queries and tables. I need to be able to get the average of a product for the months on a given query. Do I need another table and if so how do I set it up and link it?? Thanks.

I have a crosstab query that takes data from multiple customers and combines it based on product sold. I want an average of the product sales across the months provided. For example, if it is March I want an average of the sales of a given product thru March (so not divided by 12). I have it...

Can someone please help me with this? I have a very similar situation. I have a crosstab query that shows the following : Terminal Product Jan Feb etc. Total for Year Average for Year xyz abc 45 52 97 NOT WORKING I have it...