Question Crosstab Average Monthly Demand

[lite4d]

My database has a crosstab query that counts the number of hits by month. I have two columns that are named "Count of Material"(Frequency) and "Sum of ordered Qty"(Total ordered). I need add a colum to find the Average Monthly Demand by dividing the Total ordered/Frequency/number of months in the query. I have tried everything to make it work but can't. I know its right in front of me but that is where it always gets lost!

Thanks in advance!

Chris

 

[plog]

Can you post some sample data? Give me 2 sets:

A: Initial starting data from your table
B: resulting data based on A

Be sure to include table and field names. Use this format for posting:

TableNameHere
Field1Name, Field2Name, Field3Name, ...
David, 44, 5/1/2013
Sally, 39, 6/1/2009
Larry, 220, 7/7/2008

 

[lite4d]

Here is the datasheet view and the design view. I need to divide the "Total Ordered" by the "Frequency" by the number of months listed on the query.

 

[plog]

Here's an image of a 4 cylinder tubular exhaust manifold:

 

[lite4d]

Here's an image of a 4 cylinder tubular exhaust manifold:

Was the data what you needed?

 

[plog]

Nope. I would like sample data from the relevant fields in NotFilledNotCarried. Then, based on that sample data, I would like what your ultimate query should return. I don't want code or explanations, just 2 sets of data--before and after.

 

[lite4d]

Nope. I would like sample data from the relevant fields in NotFilledNotCarried. Then, based on that sample data, I would like what your ultimate query should return. I don't want code or explanations, just 2 sets of data--before and after.

AUG-13 SEPT-13 OCT-13 Frequency Total Ordered QTY AMD
1 1 1 3 5 .55


Them AMD is what I'm after. The others I have but cant get the formula to work right in the crosstab. I get it to work in the report.

Thanks for the help

 

[plog]

Well, I tried. Good luck to you.