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 da...
Yeah. I tried that, but for the life of me could not make it do the sumations.
If I do link the records don’t you have to link the records you want and it doesn’t automatically link newly added records in Table 1?
Hey Scott, thanks for the reply. …Man… that’s a serious bummer and something that should be a basic feature for a relational database.
I already have Table 1 grouped, but would like to summarize and calculate the compiled data in Table 2. hmmm… Loo...
