W
William Poh Ben
Hi,
Appreciate if anyone can help me on this. Thanks.
PartNumber2 Jun Jul Aug Count Total Ave
1370001 2 8 0 2 10 5
1370001 3 0 5 2 8 4
1370001 1 4 7 3 12 4
1700042 4 6 6 3 16 5
1840059 1 0 0 1 1 1
1840059 4 0 10 2 14 7
1951148 9 0 7 2 16 8
1344492 0 0 8 1 8 8
Do you know in MS ACCESS2000 what query to use in order to create
additional Fields on "Count", "Total" and "Average" that will compute
the Jun to Aug data for each PartNumber2 ?
"Count" refers to the number of values >0 from June to Aug.
"Total" refers to sum of values from Jun to Aug.
"Ave" means Average = "Total/Count"
When I lookup the table PartNumber1 to Table PartNumber2 and want to
calculate the "SumOfTotals" or Totals for non-duplicate, non-repeated
PartNumber2, what query to use so that I can obtain the result as
follow:
PartNumber1 SumOfTotals
1370001 30
1700042 16
1840059 15
1378902 0
1511102 0
1951148 0
Appreciate if anyone can help me on this. Thanks.
PartNumber2 Jun Jul Aug Count Total Ave
1370001 2 8 0 2 10 5
1370001 3 0 5 2 8 4
1370001 1 4 7 3 12 4
1700042 4 6 6 3 16 5
1840059 1 0 0 1 1 1
1840059 4 0 10 2 14 7
1951148 9 0 7 2 16 8
1344492 0 0 8 1 8 8
Do you know in MS ACCESS2000 what query to use in order to create
additional Fields on "Count", "Total" and "Average" that will compute
the Jun to Aug data for each PartNumber2 ?
"Count" refers to the number of values >0 from June to Aug.
"Total" refers to sum of values from Jun to Aug.
"Ave" means Average = "Total/Count"
When I lookup the table PartNumber1 to Table PartNumber2 and want to
calculate the "SumOfTotals" or Totals for non-duplicate, non-repeated
PartNumber2, what query to use so that I can obtain the result as
follow:
PartNumber1 SumOfTotals
1370001 30
1700042 16
1840059 15
1378902 0
1511102 0
1951148 0