kenhank
August 31st, 2010, 12:24 PM
I have a 2 tables:
One named GRACE with a field named HISTORY where numbers reside.
The second named NUMHISTORY.
I have 30 different numbers which range from 0 to 5 in GRACE.
I want to bring the total of each individual number into NUMHISTORY.
This should be an automatic update since new numbers come in every week.
Example:
0 = 3
1 = 10
2 = 2
3 = 12
4 = 2
5 = 1
What function would you suggest? I have a relationship established between the tables.
Thanks for your help in advance,
One named GRACE with a field named HISTORY where numbers reside.
The second named NUMHISTORY.
I have 30 different numbers which range from 0 to 5 in GRACE.
I want to bring the total of each individual number into NUMHISTORY.
This should be an automatic update since new numbers come in every week.
Example:
0 = 3
1 = 10
2 = 2
3 = 12
4 = 2
5 = 1
What function would you suggest? I have a relationship established between the tables.
Thanks for your help in advance,