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:
I want Table 2 to sum up all the widgets by date. So I would want Table 2 to show…
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!