W
William Poh Ben
I have in ACCESS2000 over 2 hundred thousands records of PartNumber with
qty usage over a period of 24 months. For a long time I have not been
able to create a query or update query to compute another 4 columns of
data - count, sum or total, Average and the Max.
If someone can please teach me how to do this, I will truly appreciate
your help. It would certainly solve my months of nightmare !
Thousands of thanks in advance !
Product Apr May Jun Jul Aug Count Sum Ave Max
77443A 2 1 0 3 6 4 12 3
6
77440A 1 4 5 0 0 3 10 3.3
5
77433B 2 1 3 2 2 5 10 2
3
77441A 5 3 1 0 0 3 9 3
5
77424B 7 4 3 2 6 5 22 4.4 7
qty usage over a period of 24 months. For a long time I have not been
able to create a query or update query to compute another 4 columns of
data - count, sum or total, Average and the Max.
If someone can please teach me how to do this, I will truly appreciate
your help. It would certainly solve my months of nightmare !
Thousands of thanks in advance !
Product Apr May Jun Jul Aug Count Sum Ave Max
77443A 2 1 0 3 6 4 12 3
6
77440A 1 4 5 0 0 3 10 3.3
5
77433B 2 1 3 2 2 5 10 2
3
77441A 5 3 1 0 0 3 9 3
5
77424B 7 4 3 2 6 5 22 4.4 7