Here is what I am trying to do.
Table 1 has two fields (date, # widgets)
Table 2 has two fields (date, total widgets)
Table 1 has 4 records. Here they are:
1/1/2020, 2
1/1/2020, 5
1/7/2020, 1
1/7/2020, 1
I want Table 2 to sum up all the widgets by date. So I would want Table 2 to show…
1/1/2020, 7
1/7/1010, 2
How can I do this? I would manually add the date in Table 2 and the Total Widgets field would automatically add up the # Widgets field from Table 1 based on the date.
Is it possible to do this? If so… how?
Thanks so much!